Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

user permissions to only for view Expand / Collapse
Author
Message
Posted Friday, October 11, 2013 1:20 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 8:58 AM
Points: 5,077, Visits: 8,918
i have log on with james..he can see all database names and logins ( he can not able to access)..he can acess system databases..even user can query system databases

Is that a problem? As you said, he can't actually access those databases and logins. He may be able to query system databases, but he'll only see things he has permissions on. For example, he won't get a full result set from sys.server_principals. Like I said, he'll still be able to do everything that the public role can do.

how can i restrict?? is it secured..??

That depends on how secure you need it to be. If necessary, you can remove permissions from public, or you can revoke or deny server level permissions from james.

if i run above query then the user can not see any databases including the database which he has acces to only view

Does that matter? He can still run queries against the view. Do you actually need him to be able to see it in Object Explorer as well?

John
Post #1503897
Posted Sunday, October 13, 2013 4:23 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, April 14, 2014 8:19 AM
Points: 306, Visits: 461
$w@t (10/9/2013)
after login with taht user i can see systemtables,system stored procedures,another users(even i can modify it) under particular database...but i want to restrict that..


If you map the user to the database that contains the view only and add that view as a securable with SELECT permissions only, your requirements would be met.
Post #1504250
Posted Monday, October 14, 2013 5:05 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, March 04, 2014 8:34 AM
Points: 43, Visits: 178
Kindly check what permissions/access you have given to the public role
Post #1504399
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse