db_owner and administrator role

if I associated an user to role : db_owner, he has automatically
administrator role or I have to define another thing ? I yes what I have to do
thanks
ftctd
"ft" <ft@.discussions.microsoft.com> schrieb im Newsbeitrag
news:03C6FD05-1A7B-40AA-A45F-C5B9AE5A57B5@.microsoft.com...
> if I associated an user to role : db_owner, he has automatically
> administrator role or I have to define another thing ? I yes what I have
> to do
> thanks
> ftct|||Db_owner "automagically" give you the aapropiate permission as an
aadministrator in the database:
From BOL:
db_owner Performs the activities of all database roles, as well as
other maintenance and configuration activities in the database. The
permissions of this role span all of the other fixed database roles.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"ft" <ft@.discussions.microsoft.com> schrieb im Newsbeitrag
news:03C6FD05-1A7B-40AA-A45F-C5B9AE5A57B5@.microsoft.com...
> if I associated an user to role : db_owner, he has automatically
> administrator role or I have to define another thing ? I yes what I have
> to do
> thanks
> ftct|||Hi,
If you allocate db_owner previlage to an user, that particular user will be
an administrator in that database. He can perform all the activities inside
that database
like Backup Restore, Create table, Truncate table, setting previlages ...
But he can not do any activities in configuration parameters or any changes
to other database.
But if you set the SYSADMIN Server role automatically user can perform any
task in all databases as well as he can change the server config parameters.
Thanks
Hari
SQL Server MVP
"ft" <ft@.discussions.microsoft.com> wrote in message
news:03C6FD05-1A7B-40AA-A45F-C5B9AE5A57B5@.microsoft.com...
> if I associated an user to role : db_owner, he has automatically
> administrator role or I have to define another thing ? I yes what I have
to do
> thanks
> ftct