Backup permission

Hello,
I=B4ve some SQL Server databases that the backups are being=20
made with integration of the Omniback Online Agent for SQL=20
Server. At this moment i=B4ve one user configured for this=20
integration and everything goes fine but the problem is=20
that this user have 'Sysadmin' permissions, if i remove=20
the user from the sysadmin in sql server i can do it if i=20
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the=20
permissions of this user and if i give(put) this user in=20
the db_backupoperator database role, that is suposed to=20
work, when running the backup the report shows 0(zero)KB=20
done.
How can i resolve this issue? I really need to limit the=20
access of this user for security and administration=20
pruposes.
Best RegardsYou can either grant backup database permissions or put the person in the
db_backupoperator . Either will do what you wish...It works in SQL, perhaps
the Tool you are using is having a problem.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||No need to start a new thread for this. I replied a few days ago that you ne
ed to check with the vendor of the
tool. It is likely that the tool vendor need you to be sysadmin, ignoring th
e fact that SQL Server allow you
to do backup is you are db_backupoerator (etc).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message news:1991601c
44d47$0a128860$a501280a@.phx.gbl...
Hello,
Ive some SQL Server databases that the backups are being
made with integration of the Omniback Online Agent for SQL
Server. At this moment ive one user configured for this
integration and everything goes fine but the problem is
that this user have 'Sysadmin' permissions, if i remove
the user from the sysadmin in sql server i can do it if i
give to this user the 'db owner' permission.
Until now everything looks fine and normal.
My question is that i want to restrict to the maximum the
permissions of this user and if i give(put) this user in
the db_backupoperator database role, that is suposed to
work, when running the backup the report shows 0(zero)KB
done.
How can i resolve this issue? I really need to limit the
access of this user for security and administration
pruposes.
Best Regards|||Thanks Tibor,
I use this text to put one post in HP forums but got no=20
answer.
Other thing that i dont understand is that when a user is=20
member of the db_backupoperator and use this user to=20
register in Enterprise Manager(to test backups), when i=20
need to choose the location for the backup the following=20
error appear (ERROR 229: Execution permissions denied=20
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything

>--Original Message--
>No need to start a new thread for this. I replied a few=20
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be=20
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--=20
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in=20
message news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
>Hello,
>I=B4ve some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment i=B4ve one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>|||Wayne
If he puts the user in the db_backupoperator and then would try to restore
database that does not exists so he will get an error. In this case he will
have to put the user in the dbcreator server role.
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OBDR3mUTEHA.3332@.tk2msftngp13.phx.gbl...
> You can either grant backup database permissions or put the person in the
> db_backupoperator . Either will do what you wish...It works in SQL,
perhaps
> the Tool you are using is having a problem.
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
> news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
> Hello,
> Ive some SQL Server databases that the backups are being
> made with integration of the Omniback Online Agent for SQL
> Server. At this moment ive one user configured for this
> integration and everything goes fine but the problem is
> that this user have 'Sysadmin' permissions, if i remove
> the user from the sysadmin in sql server i can do it if i
> give to this user the 'db owner' permission.
> Until now everything looks fine and normal.
> My question is that i want to restrict to the maximum the
> permissions of this user and if i give(put) this user in
> the db_backupoperator database role, that is suposed to
> work, when running the backup the report shows 0(zero)KB
> done.
> How can i resolve this issue? I really need to limit the
> access of this user for security and administration
> pruposes.
> Best Regards
>|||As Uri said, the db_backupoperator is a very limited permission, which
evidently does NOT include permission to use the extended procedure you
mentioned.
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:1952a01c44d4e$de357650$a601280a@.phx
.gbl...
Thanks Tibor,
I use this text to put one post in HP forums but got no
answer.
Other thing that i dont understand is that when a user is
member of the db_backupoperator and use this user to
register in Enterprise Manager(to test backups), when i
need to choose the location for the backup the following
error appear (ERROR 229: Execution permissions denied
on 'xp_availablemedia'...)
I dont understand.
Thanks for eveything

>--Original Message--
>No need to start a new thread for this. I replied a few
days ago that you need to check with the vendor of the
>tool. It is likely that the tool vendor need you to be
sysadmin, ignoring the fact that SQL Server allow you
>to do backup is you are db_backupoerator (etc).
>--
>Tibor Karaszi, SQL Server MVP
>http://www.karaszi.com/sqlserver/default.asp
>http://www.solidqualitylearning.com/
>
>"CC&JM" <anonymous@.discussions.microsoft.com> wrote in
message news:1991601c44d47$0a128860$a501280a@.phx
.gbl...
>Hello,
>Ive some SQL Server databases that the backups are being
>made with integration of the Omniback Online Agent for SQL
>Server. At this moment ive one user configured for this
>integration and everything goes fine but the problem is
>that this user have 'Sysadmin' permissions, if i remove
>the user from the sysadmin in sql server i can do it if i
>give to this user the 'db owner' permission.
>Until now everything looks fine and normal.
>My question is that i want to restrict to the maximum the
>permissions of this user and if i give(put) this user in
>the db_backupoperator database role, that is suposed to
>work, when running the backup the report shows 0(zero)KB
>done.
>How can i resolve this issue? I really need to limit the
>access of this user for security and administration
>pruposes.
>Best Regards
>
>.
>