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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Missing dbo grantor on some tables

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.
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page

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
Go to Top of Page

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.
Go to Top of Page
   

- Advertisement -