September 24, 2009 at 2:31 am
I have been asked to create two schemas and users. there are no objects in DB.
user must have full on the created schema objects i.e select insert delete and insert alter.
Please guide me how to do this.
September 24, 2009 at 2:51 am
ramuvanparti (9/24/2009)
I have been asked to create two schemas and users. there are no objects in DB.user must have full on the created schema objects i.e select insert delete and insert alter.
Please guide me how to do this.
Can you supply more details on what you need, like examples for instance.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 24, 2009 at 3:31 am
suppose i have db name test and there no objects in this db now whenever user of this database will create a object that should in either of these schemas only. and user should have full access to thses schema only
i have create two schemas "sche1", "sche2"
user as name "ramu"
September 24, 2009 at 4:04 am
ramuvanparti (9/24/2009)
suppose i have db name test and there no objects in this db now whenever user of this database will create a object that should in either of these schemas only. and user should have full access to thses schema onlyi have create two schemas "sche1", "sche2"
user as name "ramu"
As an example, you can say
GRANT SELECT ON SCHEMA :: schel1 to ramu
you might also consider using
ALTER USER [ramu] WITH DEFAULT_SCHEMA=[sche1]
these are purely examples. more information can be obtained by looking at BOL.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 24, 2009 at 4:26 am
thanks
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply