Enterprise Manager and Windows Account
From: Tabassum (Tabassum@sys.net.pk)
Date: 11/28/02
- Next message: Jacky: "Re: Need some security suggest"
- Previous message: BP Margolin: "Re: Queries Fired"
- Next in thread: Vishal Parkar: "Re:Enterprise Manager and Windows Account"
- Reply: Vishal Parkar: "Re:Enterprise Manager and Windows Account"
- Reply: SQL Server Development Team [MS]: "Re: Enterprise Manager and Windows Account"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Tabassum" <Tabassum@sys.net.pk> Date: Thu, 28 Nov 2002 14:54:38 +0500
Dear All,
I wanted to a samll question about security in enterprise manager and normal
user accounts.
I have SQL2k on win2k server and normally all administration work is the
carried out using administrator account. my manage wants to give backup and
restore task to a newly hired person in our organization, but he do not want
to give the admin password to him
His account is in the USERS group in Win2k
I have to add the user (with his login) in the required database and assign
him the backup operator role.??
I also want to know if i give him backup operator role can he access the
data in tables by opening them in EM?
an early response will be highly appreciated.
kind regards
Tabassum
- Next message: Jacky: "Re: Need some security suggest"
- Previous message: BP Margolin: "Re: Queries Fired"
- Next in thread: Vishal Parkar: "Re:Enterprise Manager and Windows Account"
- Reply: Vishal Parkar: "Re:Enterprise Manager and Windows Account"
- Reply: SQL Server Development Team [MS]: "Re: Enterprise Manager and Windows Account"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|