Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alifeyzo
Starting Member
2 Posts |
 Posted - 2009-08-21 : 05:23:46
|
| Hi all,I created a new login, and tried to set restrictions on it, but I couldn't. This new login must see only "X001" database. How can I do it? I tried this:1. Created a new login2. Set default db as "X001"3. Mapped this login on "X001" db4. with using "server type object" on its properties, I denied WIEW ANY DATABASE option.When I log-in as new login, I can only see System Databases (not "X001")Thanks. |
|
|
|
|
|
login restriction