Access 2003; SQL Server 2000
I upsized a Database using the sa account. I'm trying to grant a NT Domain group DBO access and permission to all the objects. I thought that giving a group dbo_owner
access would solve my problem. However when I look in Enterprise manager, my group does not have even have select permissions. However, it is a dbo_owner. When I change the connection to windows authentication and attempt to connect with my account (a member of the group) nothing works.
I ran the following...
Exec sp_grantlogin 'Domain\Developer'
Exec sp_grantdbaccess 'Domain\Developer'
Exec sp_addrolemember 'db_owner', 'Domain\Developer'
It seems to me that being a db_owner should allow all permission to the objects. Do I need to explicitly grant permissions?
How do I ensure that my user account behaves in the context of dbo so that ownership stays intact?
I know just enough to be dangereous, so any help would be much appreciated. This is my first development with an ADP and my SQL Server skills are intermediate <I hope>.
I upsized a Database using the sa account. I'm trying to grant a NT Domain group DBO access and permission to all the objects. I thought that giving a group dbo_owner
access would solve my problem. However when I look in Enterprise manager, my group does not have even have select permissions. However, it is a dbo_owner. When I change the connection to windows authentication and attempt to connect with my account (a member of the group) nothing works.
I ran the following...
Exec sp_grantlogin 'Domain\Developer'
Exec sp_grantdbaccess 'Domain\Developer'
Exec sp_addrolemember 'db_owner', 'Domain\Developer'
It seems to me that being a db_owner should allow all permission to the objects. Do I need to explicitly grant permissions?
How do I ensure that my user account behaves in the context of dbo so that ownership stays intact?
I know just enough to be dangereous, so any help would be much appreciated. This is my first development with an ADP and my SQL Server skills are intermediate <I hope>.