471,573 Members | 1,160 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,573 software developers and data experts.

only authorized users can access the database in enterprise manager in MSSQL Server


I want to give password when we open the enterprise manager .So that only the authorised users can access the database & see the tables .

Could u help me for solving this problem.
& Also tell me is it posible or not.

very urgent...........reply soon
Dec 15 '06 #1
2 1596
1,017 Expert 512MB
If user's rights are restricted - he can't do much through Enterprise Manager.
Revoke all unwanted rights from users.
Dec 15 '06 #2
tell me is it possible that first we enter the login name & password
if it is valid , only that user can see the database.

I want to do..............

If possible then how will be done.
Dec 16 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by mark | r | last post: by
11 posts views Thread by Taishi | last post: by
7 posts views Thread by sanjitg via SQLMonster.com | last post: by
5 posts views Thread by Al Jans | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by Vinnie | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.