I'm trying to grant a user full access to a database.
Although I've given this user the role of db_owner, he still doesnt have the
same access as ,for example, the "dbo" user.
When I look at the table permissions, the "dbo" user has everything selected
while my user has nothing selected. Do I have to go into each table and
manually assign these permissions or can I somhow apply all of the
permissions using the database roles?
Problem is w/ .ADP..Re: SQL db Permissions for users not working ... You do not have SELECT permissions on the ... SysObjects system table in the database.... figured out that qualifying the database owner (dbo in my ... >> I feel that the object owner is not dbo, ... (microsoft.public.sqlserver.security)
Re: How to prevent DELETEs in a table ... It is the dbo database USER, not server-level groups, that determins ... It has implicit permissions that can not be denied. ...SQL Server just skips any permission validation for sysadmins. ... (microsoft.public.sqlserver.server)
Re: Delegate Power of God to only 1 database - How? ... Guess I'll have to look more closely at the permissions... >I support the Professional Association for SQL Server... >> permissions to only that database which can be assigned ... >>>Exactly what is this 'dBO' role you are referring to? ... (microsoft.public.sqlserver.security)
Re: A User wants DBO on a production db ... only statement permissions would fail if the user has the ...dbo) and data access is only through stored procedures, ...production DBA is to ensure the stability and integrity of the ... prod DBA is at odds with the ad-hoc changes to the production database.... (microsoft.public.sqlserver.security)
Re: Delegate Power of God to only 1 database - How? ...permissions to only that database which can be assigned to ... a specific database without using Windows authentication... ... >Exactly what is this 'dBO' role you are referring to? ... >> Create a SQL User account which has full ... (microsoft.public.sqlserver.security)
