**Create Login **

Hi
I want to create a new login "L1" in SQL 2000 and let him to be as L1's
owner and can backup and restore it too,I selected the "public" and
"db_owner" in Enterprise manager as I defined the login name ,but what
should I choose to let him to do "backup & restore db" too?
Any help wolud be thankful.Nothing. Members of the db_owner database role can backup and restore
databases of which they are the owner. If you want to give a login
permissions to backup and restore a database of which they are not the
owner, you can make them a member of the db_backupoperator database role.
Jacco Schalkwijk
SQL Server MVP
"maryam rezvani" <rezvani@.parskhazar.net> wrote in message
news:usUBP3DNFHA.3336@.TK2MSFTNGP10.phx.gbl...
> Hi
> I want to create a new login "L1" in SQL 2000 and let him to be as L1's
> owner and can backup and restore it too,I selected the "public" and
> "db_owner" in Enterprise manager as I defined the login name ,but what
> should I choose to let him to do "backup & restore db" too?
> Any help wolud be thankful.
>
>|||I created L1 with db_owner of DB1 ,but when I changed my enterprise manger
by logining through L1 and wanted to restore DB1's backup as DB2 following
error appearred:
"Create databae permission denied in databade master, restore database is
terminated abnormally."
so,I think it's not enough just to check "public" and "db_owner" for L1 in
DB1,why?
can anybody help me?
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:OZ9GDHENFHA.2384@.tk2msftngp13.phx.gbl...
> Nothing. Members of the db_owner database role can backup and restore
> databases of which they are the owner. If you want to give a login
> permissions to backup and restore a database of which they are not the
> owner, you can make them a member of the db_backupoperator database role.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "maryam rezvani" <rezvani@.parskhazar.net> wrote in message
> news:usUBP3DNFHA.3336@.TK2MSFTNGP10.phx.gbl...
>|||If a login is a member of the db_owner role, it has the permissions to
backup and restore that database. What you want to do is create a new
database, and restore the original database over that. For that the login
needs to be a member of the dbcreator fixed server role or you have to grant
the permission with GRANT CREATE DATABASE TO L1. The latter gives less
permissions, as the login won't be allowed to drop or alter other databases
than the one he has created. Creating a database automatically as the
creating login to the db_owner role.
Jacco Schalkwijk
SQL Server MVP
"maryam rezvani" <rezvani@.parskhazar.net> wrote in message
news:OF0Ik2ENFHA.2704@.TK2MSFTNGP15.phx.gbl...
>I created L1 with db_owner of DB1 ,but when I changed my enterprise manger
> by logining through L1 and wanted to restore DB1's backup as DB2 following
> error appearred:
> "Create databae permission denied in databade master, restore database is
> terminated abnormally."
> so,I think it's not enough just to check "public" and "db_owner" for L1 in
> DB1,why?
> can anybody help me?
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid>
> wrote
> in message news:OZ9GDHENFHA.2384@.tk2msftngp13.phx.gbl...
>|||Thanks I tried as you said and I've got following error at the end of
progression of a blue bar(showing restore action)
"Server user L1 is not a valid user in database DB2 ,restore database is
terminated abnormally."
as a result the database restored but L1 has no access to DB2!!!!
what should I do?
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:#QvAMBFNFHA.2704@.TK2MSFTNGP15.phx.gbl...
> If a login is a member of the db_owner role, it has the permissions to
> backup and restore that database. What you want to do is create a new
> database, and restore the original database over that. For that the login
> needs to be a member of the dbcreator fixed server role or you have to
grant
> the permission with GRANT CREATE DATABASE TO L1. The latter gives less
> permissions, as the login won't be allowed to drop or alter other
databases
> than the one he has created. Creating a database automatically as the
> creating login to the db_owner role.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "maryam rezvani" <rezvani@.parskhazar.net> wrote in message
> news:OF0Ik2ENFHA.2704@.TK2MSFTNGP15.phx.gbl...
manger
following
is
in
role.
what
>|||Can you give the _exact_ steps you take (which permissions you have assigned
to L1, which database you restore to where, etc), and the _exact_ error
message you get? (There is no such thing as a "server user" in Microsoft SQL
Server)
Jacco Schalkwijk
SQL Server MVP
"maryam rezvani" <rezvani@.parskhazar.net> wrote in message
news:e8ags$ONFHA.3560@.TK2MSFTNGP14.phx.gbl...
> Thanks I tried as you said and I've got following error at the end of
> progression of a blue bar(showing restore action)
> "Server user L1 is not a valid user in database DB2 ,restore database is
> terminated abnormally."
> as a result the database restored but L1 has no access to DB2!!!!
> what should I do?
> "Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid>
> wrote
> in message news:#QvAMBFNFHA.2704@.TK2MSFTNGP15.phx.gbl...
> grant
> databases
> manger
> following
> is
> in
> role.
> what
>|||Thanks
"Jacco Schalkwijk" <jacco.please.reply@.to.newsgroups.mvps.org.invalid> wrote
in message news:euWLXiPNFHA.2736@.TK2MSFTNGP09.phx.gbl...
> Can you give the _exact_ steps you take (which permissions you have
assigned
> to L1, which database you restore to where, etc), and the _exact_ error
> message you get? (There is no such thing as a "server user" in Microsoft
SQL
> Server)
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "maryam rezvani" <rezvani@.parskhazar.net> wrote in message
> news:e8ags$ONFHA.3560@.TK2MSFTNGP14.phx.gbl...
login
database
L1
<jacco.please.reply@.to.newsgroups.mvps.org.invalid>
restore
the
as
and
>