Viewing access privileges

Поиск
Список
Период
Сортировка
Искать

Viewing access privileges

От:
Stephen Davies <scldad@sdc.com.au>
Дата:
How can one view all of the access privileges of one or more users?

That is, how can I check what I have GRANTed to whom?

Also, where can I look to find answers to questions such as "what is the 
function that returns today's date for a default column value"?

Cheers and thanks,
Stephen Davies.


========================================================================
Stephen Davies Consulting	    		                            scldad@sdc.com.au
Adelaide, South Australia.     			                            Voice: 61-8-82728863
Computing & Network solutions.	 	                            Fax: 61-8-82741015

Re: [SQL] Viewing access privileges

От:
"Tim J Trowbridge" <trowbrid@execpc.com>
Дата:
Stephen Davies wrote:
> 
> How can one view all of the access privileges of one or more users?
> 
> That is, how can I check what I have GRANTed to whom?

Try this:
SELECT relname,relacl FROM pg_class WHERE relname !~ '^pg_';

-- 
Tim J Trowbridge                         trowbrid@writeme.com
Interested in my genealogy?          http://www.execpc.com/~trowbrid
FAQ