Guest_imported
New member
- Jan 1, 1970
- 0
I don't want any of my users to open any object of the database in Enterprse Manager without having a valid password. How do I achieve this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I protect Enterprise Manager?
- Thread starter Guest_imported
- Start date
- Status
AshleyRickards
MIS
On each of your databases, right click and select 'Edit SQL Registration properties'. Instead of using Windows Auth. use SQL and select the option to prompt for password. Ashley L Rickards
SQL DBA
SQL DBA
tlbroadbent
MIS
Assign the user to the db_denydatareader and db_denydatawriter database roles. They won't be able to read, write or even view the tables. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
