Re: Assigning Permissions to a Database

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

"Dan Guzman" <guzmanda@xxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:%23W$9p9$ZGHA.5088@xxxxxxxxxxxxxxxxxxxxxxx
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.

--
Hope this helps.

Dan Guzman
SQL Server MVP

"newbie" <newbie@xxxxxxx> wrote in message
news:eI8ZEZ7ZGHA.4788@xxxxxxxxxxxxxxxxxxxxxxx
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!





.