July 16, 2008 at 4:21 pm
Hello,
I have a Schema by name "Common" in which I want a set of users "user1, user2, user3" to have full control on it. That means they can create, drop, select, update etc., on ANY object in that Schema.
What command should I use in TSQL to allow this permission at the schema level?. It is okay if I can issue the command at each user level.
Thanks,
Ganesh
July 16, 2008 at 5:03 pm
ganeshmuthuvelu (7/16/2008)
Hello,I have a Schema by name "Common" in which I want a set of users "user1, user2, user3" to have full control on it. That means they can create, drop, select, update etc., on ANY object in that Schema.
What command should I use in TSQL to allow this permission at the schema level?. It is okay if I can issue the command at each user level.
Thanks,
Ganesh
GRANT ALL ON SCHEMA::common TO user;
Lookup GRANT in BOL for further details.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
July 17, 2008 at 7:53 am
Thanks, I tried this earlier but I get this error:
Msg 4623, Level 16, State 1, Line 1
The all permission has been deprecated and is not available for this class of entity
which also means that ALL is NOT applicable to "schema" entitites.
-Ganesh
July 17, 2008 at 2:07 pm
Yes, you are right - ALL does not appear to be available for schema. So, you are going to have to list all of the permissions you want.
GRANT permission [ ,...n] ON SCHEMA::schema_name TO ...
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply