Security

Ask something
Discussion Locked

SQL 2000 Security

0 helpful
3 replies

by agibbs 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I need to know a way to setup multiple users on a SQL2000 Server and make sure each user can only see their own database. For example, I setup a login user1, give them DBO access to the database user1DB, and when user1 logs in with Enterprise Manager I want them to only see their own database listed (rather than all DB's on the server.)

I've tried this already, granted the login DBO access only to their own database, but all databases show up in Enterprise Manager when the user logs in. The user doesn't have rights to other databases, so if they try to open one they get an error, but I'd rather they just didn't see the other DB's at all.

3 replies

by timthetoolman

Hi,

Two things to try...

1. For each of the other databases, add the user but with no access. ie. Specifically exclude them from access from that database.

That may stop them being seen in the Enterprise manager list...or it may not.

If it doesn't, then you could possibly...

2. I believe the master database list is stored in the master database. You'd need to implement row level security on each database in that list, excluding them from all user but the one allowed.

By the way, I'd be doing this with groups rather than individual users. It's much easier to maintain.

Hope this helps.
Cheers,
Tim.

This discussion is closed to new replies.