On 07/02/2014 06:17 AM, Rich Shepard wrote:
-- Set user roles
CREATE ROLE admin LOGIN;
CREATE ROLE executive;
CREATE ROLE manager;
CREATE ROLE technician;
and my question is what do I need to do so when a user is added to the
system the local administrator and the group specified during the
createuser
process, she or he can be granted that group's privileges?
I am not following.
Can you show an example of what you are talking about?
Or, is that
automatic if the role is included in the Users table?
Assuming Users is your own table, Postgres has no way of knowing that
relates to user permissions. It stores that information in the system
catalogs.
Rich
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
