user can access only that perticular DB

Question

Post reply

user can access only that perticular DB

sql Anand

SSCommitted

Points: 1597
More actions
October 12, 2011 at 5:03 am

#246461

hi,
i create user-name and password for sql server 2008 but this user can access all the db
but i want to create user-name and password that user-name can access only one particular db in sql server 2008..
how to do this any one can help this

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Duplicate post. Replies here please: http://www.sqlservercentral.com/Forums/FindPost1189017.aspx

-- Gianluca Sartori

Lowell SSC Guru Points: 323518 More actions · Answer 2

duplicate post.

no need to cross post to multiple forums it fractures the answers you get and makes posters duplicate others work.

the "Recent Posts" link shows us everything.

continue the thread here:http://www.sqlservercentral.com/Forums/Topic1189017-1550-1.aspx

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

george sibbald SSC Guru Points: 104210 More actions · Answer 3

please don't duplicate post about duplicate posts. It just wastes space on the database

😀

---------------------------------------------------------------------

Lowell SSC Guru Points: 323518 More actions · Answer 4

george sibbald (10/12/2011)
please don't duplicate post about duplicate posts. It just wastes space on the database
😀

but...but...aww...:w00t:

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!