Assigning Permissions to a Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

newbie - 24 Apr 2006 16:46 GMT

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?

Thanks!

Reply to this Message

Dan Guzman - 25 Apr 2006 01:30 GMT

Db_owner role members and the 'dbo' user hare full permissions over all
objects in the database. There is no need to grant object permissions
because object permissions are not checked for db_owner role members.

Signature

Hope this helps.

Dan Guzman
SQL Server MVP

> I'm trying to grant a user full access to a database.
>
[quoted text clipped - 7 lines]
>
> Thanks!

Reply to this Message

mpia - 25 Apr 2006 03:02 GMT

Besides, if a user belongs to db_owner role, he isn't dbo user. For example,
if that user creates a table, this table will be created as user.tabla but
if the dbo user creates a table, this table will be created as dbo.tabla .
Then, the user should create the table hardcoding the dbo.tabla

Mpia

> Db_owner role members and the 'dbo' user hare full permissions over all
> objects in the database. There is no need to grant object permissions
[quoted text clipped - 11 lines]
>>
>> Thanks!

Reply to this Message