Link to home
Start Free TrialLog in
Avatar of Jay P
Jay PFlag for United States of America

asked on

sql server - how to set password before allowing access to db

Hi Experts,
I want to set a password so that a password is required before anyone can see the tables or stored proc in an sql server 2000 db. It is on a win xp pro environment. How can I do that using EM. Thanks in advance for help
Avatar of arnold
arnold
Flag of United States of America image

disabled the public access.  Lookinto the login/security/users in EM.  Disabling the Windows login access into the SQL is another approach.
ASKER CERTIFIED SOLUTION
Avatar of nayernaguib
nayernaguib
Flag of Egypt image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial