May 11, 2009 at 4:40 am
Hi All,
I want to create two login A and B. I need to specify that user A has the rights to create table in his own login, but not in any other.
Please help me out.
Thanks.
May 11, 2009 at 5:37 am
Hi,
Can you be more specific....
what do you mean by this statement:
"I need to specify that user A has the rights to create table in his own login, but not in any other".
-Vikas Bindra
May 11, 2009 at 5:43 am
You can grant specific users granular privileges to perform actions against many database objects.
Can you provide more information?
For example, do you mean that you need to create to users, A and B and that user A will be allowed to create tables in database 1 but user B can't?
--
Andrew Hatfield
May 11, 2009 at 6:09 am
Hi Vikas and Andrew,
I have created two logins, login A and B. After that, I made the Login A as db_owner and create a new schema with the name of A. I also created a new schema for login B.
After doing this, I am able to create, update and delete any table of Login B from Login A . I want to restrict Login A to do these things.
Please also suggest if is there any better way to do this thing.
May 11, 2009 at 6:20 am
Can you access only that particular database or full databases......Did you mapped logins for databases
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply