Обсуждение: Security Query

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

Security Query

От
Carol Walter
Дата:
Is there a query I can run that will tell me what access my users
have to various database objects?

Thanks,
Carol Walter

Re: Security Query

От
Vishal Arora
Дата:

From the psql client, you can view ACL permission summaries by using the \z slash command. This command displays all access permissions in the currently connected database. To see permissions on a specific object, specify that object's name as a parameter to the \z command. You can use a regular expression in place of a name to see privileges on a group of objects.
 
http://www.faqs.org/docs/ppbook/x19270.htm 



> To: pgsql-admin@postgresql.org
> From: walterc@indiana.edu
> Subject: [ADMIN] Security Query
> Date: Mon, 12 Nov 2007 09:22:35 -0500
>
> Is there a query I can run that will tell me what access my users
> have to various database objects?
>
> Thanks,
> Carol Walter
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster



Climb to the top of the charts!  Play Star Shuffle:  the word scramble challenge with star power. Play Now!