Cascading roles

Database
N/A

Cascading roles

I would like to know if there is a way to automatically grant a role to a child.

If UserA owns UserB, UserC, and UserD, I would like to be able to grant role_basic_rights to UserA and have that right automatically granted to UserB, UserC, UserD and any future users that will be owned by UserA.

3 REPLIES

Re: Cascading roles

did you try: grant select on database.tablename to all marketing_folks;

the database marketing_folks would have all "users" as a child of database marketing_folks.

Re: Cascading roles

sorry...
as far as cascading role(s) to childen its a no go.
SN
N/A

Re: Cascading roles

hi,

Owners have the implicit privilage to grant privilages on their owned objects (sans SP). However, a new user must be explicitely granted all CREATE (profile,role,procedure,database,user) privilages, even on his/her default database.