February 15, 2011 at 11:56 pm
dear Group,
i have five databases (i.s A,B,C,D,E). i create a login for user to access only A database. when i check this login i found it uses all database or it can access any database .
so i need help how to create login and their permissions if i assign only a database access it can only use and access only A not others .
Vimal Kumar
9999797952
February 16, 2011 at 12:15 am
While creating login that can access a particular database you need to map that database which you want to give access.It can be done by going to User mapping option while creating logins & checking the database which you want to give the access to & what roles you want to assing can be specified over there
February 16, 2011 at 12:21 am
yes i have already done . but still i don't got any success .
if you don't mine can i talk wid you on phone
please me your contact no
othe wise i explain you
Vimal Kumar
9999797952
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply