|
||
|
Activity:
2 comments
1968 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
|
|
SQL SERVER VS ORACLE |
|
|
3 referals
10 arguments,
189 views
|
|
|
Which one is more better secure ? |
|
|
1 referals
17 arguments,
1311 views
|
|
|
Policy-Based Management Policy-Based Management enables the efficient management of multiple SQL... |
|
|
593 referals
11 comments,
127 views
|
|
|
|
|
|
|
|
|
The new models, the E6 and the X7, will go on sale for 340 euros ($491.6) and 380 euros... |
|
|
1624 referals
13 comments,
184 views
|
|
|
Views in SQL Server View A view is a virtual table that consists of columns from one or more... |
|
|
6 referals
2 comments,
237 views
|
|
|
Hide Facebook from your boss by converting it into an Excel sheet ! Melbourne, July 06 (ANI):... |
|
|
89 referals
5 comments,
32 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... |