November 4, 2008 at 6:20 pm
i was told to grant select,update,delete and insert permissions to a user xyz..now there is a defined role brf.tool....and then there is db brf_9...this is wat i did..i would really appreciate if someone could suggest or give feedback whether it is right or not
1)i went to the server where db brf_9 is present...went to security folders then logins...i dnt see the user by the login name xyz...but i see many groups and different users...could it be possible that xyz is under some group....is der anyway to find out under which group he is or should i ask him..
2)then i would right click either on the group or login and go to prop..user mapping select the db in this case brf_9..should the default schema be dbo or something else..
3) then i would select the role brf.tool
4)do i have to do anything with the server roles?
5)then i will go to the db brf_9 select the user and select the permissions select,update,insert and delete..
sorry for being lengthy...my boss just told me ders a role brf.tool..how wld i know whether it is a db role or server role...
i wld really appreciate for suggestions..thx in advance
November 4, 2008 at 7:33 pm
iqtedar (11/4/2008)
i was told to grant select,update,delete and insert permissions to a user xyz..now there is a defined role brf.tool....and then there is db brf_9...this is wat i did..i would really appreciate if someone could suggest or give feedback whether it is right or not1)i went to the server where db brf_9 is present...went to security folders then logins...i dnt see the user by the login name xyz...but i see many groups and different users...could it be possible that xyz is under some group....is der anyway to find out under which group he is or should i ask him..
2)then i would right click either on the group or login and go to prop..user mapping select the db in this case brf_9..should the default schema be dbo or something else..
3) then i would select the role brf.tool
4)do i have to do anything with the server roles?
5)then i will go to the db brf_9 select the user and select the permissions select,update,insert and delete..
sorry for being lengthy...my boss just told me ders a role brf.tool..how wld i know whether it is a db role or server role...
i wld really appreciate for suggestions..thx in advance
I don't know if this is a sql login or a windows login, but if it's a SQL login there are no 'server-level' groups apart from the fixed server roles. If it's a windows group that you think this user is a member of you might be able to use this command to see the members.
exec master..xp_logininfo 'domain\groupname', 'members'
even if that person is a member of a group, you need to verify that the whole group gets access to your db resources before granting any access.
whatever gets decided there, you do just like you thought through the gui and the default schema is 99% likely to be dbo.
p.s. you can't add a server role, they are fixed.
Craig Outcalt
November 4, 2008 at 7:46 pm
thank you....and when i select the group the default db should only be the db which needs access instead of master right...
November 4, 2008 at 7:56 pm
that's always a good call. Otherwise they won't be able to log in 🙂
~bot
Craig Outcalt
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply