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
Problems are opportunities brilliantly disguised as insurmountable obstacles.
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
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply