All Forums Database
JustMe 76 posts Joined 03/07
17 Apr 2008
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.

tanova535 7 posts Joined 01/06
28 Apr 2008

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.

tanova535 7 posts Joined 01/06
28 Apr 2008

sorry... as far as cascading role(s) to childen its a no go.

SN 77 posts Joined 01/07
28 Apr 2008

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.

You must sign in to leave a comment.