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 |
|
cwildeman
Starting Member
40 Posts |
 Posted - 2011-06-28 : 14:39:18
|
| Hi,I am an SQL Server 2008 R2 novice who is designing a database for other end users. I have eight tables that I want to grant Delete, Insert, Select and Update rights to my end users. I created a Group name (not sure of the term) called qr_Falls. When I right click my first two tables and choose Properties => Permissions there are two grantors listed. One is dbo and the other is me (GHS_NT1\my user name). For dbo setting for these two tables, I went through and granted the permission types listed above. However, for the other six tables, dbo appears only once with Alter as the only selection and it is checked. The other types (Delete, Insert, Select and Update) are not listed for dbo. However, my user ID (GHS_NT1\my user name) is listed for all permission types although nothing is checked.I am confused with how to set this up and how to get dbo granter to appear for the different types of permissions. Can someone help?Thanks,Chuck W |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-28 : 14:54:54
|
| dbo is the database owner and has all permissions on the tables.How does that affect permission for your role qr_Falls?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
cwildeman
Starting Member
40 Posts |
Posted - 2011-06-28 : 15:19:38
|
| A dba helped set me up and gave me admin rights for this database. Is she the dbo user? Shouldn't dbo automatically appear for all tables that I create? I am trying to figure out how to get dbo to appear? She set up qr_Falls and for each of my tables qr_Falls appears in the users or Role Name header in the permissions for each table. The type is listed as Database Role.Chuck W |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-28 : 15:28:56
|
| Are you trying to give permissions to dbo or to qr_Falls?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
cwildeman
Starting Member
40 Posts |
Posted - 2011-06-28 : 15:40:23
|
| I guess I am confused by it all. I would like to have the qr_Falls group contain about four users which the dba will add in active directory. She set up qr_Falls somewhere in Management Studio and said to go into each table and check grant to the permission types I mentioned above for my eight tables. But dbo is only listed as Alter in six of the eight tables. I could ask her but she is unavailable for now. did I answer your questions?Chuck W |
|
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-06-28 : 16:25:36
|
| I think so.You aren't interested in dbo so ignore it woud be my advice.If the role has been granted the permissins you want then that's all you need to do.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Missing dbo grantor on some tables