Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Lauri332
Starting Member
9 Posts |
 Posted - 2008-10-07 : 02:51:22
|
| Hello :)I'm really new in SQL-Server and I've the following problem:I have a group - we call it group_xy - and a database (db_123). Now I want all members of the group_xy only to be able to access to one table of the db_123. The other tables should be inaccessable for them.Could you perhaps help me in this matter?RegardsLauri |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 02:56:12
|
| by group do you mean workgroup or domain? do the domain account currently exist in db for members?If yes, you can create a role for these users in db and give the role the required accesses only for this table and not for any others. |
 |
|
|
Lauri332
Starting Member
9 Posts |
Posted - 2008-10-07 : 03:09:34
|
| Hi,thanks for your very fast answer! With group I mean a group in the Active Directory. How can I check if the account exists in the db? (Sorry I'm really new :O)... GreetsLauri |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 03:51:53
|
quote:
Originally posted by Lauri332
Hi,thanks for your very fast answer! With group I mean a group in the Active Directory. How can I check if the account exists in the db? (Sorry I'm really new :O)... GreetsLauri
Connect to server from sql management studio. expand you database->security->users and see if account exists. |
|
|
|
Lauri332
Starting Member
9 Posts |
Posted - 2008-10-07 : 04:17:47
|
| Hi again,I've done it! It works now. I've created a role with the needed restrictions.Thanks again for your help..Lauri |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 04:23:24
|
quote:
Originally posted by Lauri332
Hi again,I've done it! It works now. I've created a role with the needed restrictions.Thanks again for your help..Lauri
welcome  |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-10-07 : 09:04:54
|
| If its 1 table permission, you don't need to create role for it. Just right click that table-Properties-permission for that windows group. |
|
|
|
|
|
|
Table-Permission