|
||
|
Activity:
2 comments
1977 views
last activity : 07 06 2010 20:18:04 +0000
|
||
|
|
Question:
If a user is not authorized to see a database can I exclude that database from even appearing in SQL Server Management Studio for that specified user or group?
Answer:
Until SQL Server version 2000 it was not possible to hide the database information from being displayed on SQL Server Enterprise Manager. In SQL Server 2005 it is possible with a new server side role that has been created. VIEW ANY DATABASE permission is a new, server-level permission. A login that is granted with this permission can see metadata that describes all databases, regardless of whether the login owns or can actually use a particular database. Please note By default, the VIEW ANY DATABASE permission is granted to the public role. Therefore, by default, every user that connects to an instance of SQL Server 2005 can see all databases in the instance
|
|
Dynamic Management Views The dynamic management views (DMV’s) in SQL Server 2005 are designed... |
|
|
11 referals
6 comments,
1828 views
|
|
|
Leadership is about setting a new direction for a group; management is about directing and... |
|
|
4 referals
8 arguments,
392 views
|
|
|
The flexibility of changing in jobs is very different and difficult in India ( as far as my... |
|
|
773 referals
43 arguments,
2303 views
|
|
|
|
|
|
|
|
|
Office Etiquette or Office Manners is about conducting yourself respectfully and courteously ... |
|
|
49 referals
4 comments,
73 views
|
|
|
Successful Project Managers - Characteristics and Skills What are the Characteristics of... |
|
|
203 referals
14 comments,
11875 views
|
|
|
HI The most stressful part of job interview is to get stuck in those questions which are generic... |
|
|
0 referals
6 comments,
323 views
|
|
|
|
|
Managing a project is. right work by right people on right time, |
Like application design, database design is very critical to the scalability and performance of your SQL Server applications. And also like application design, if you don't do a good job in the first place, it is very hard and expensive to make... |
How to configure Database Mirroring I have configured database mirroring with database sansu as the principal and with following 3 instances namely, Manish --- Principal Manish\Sansu --- Mirror Manish\Test --- Monitor I have drafted the following... |