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 Thursday, October 10, 2013 12:58 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:24 PM
Points: 48, Visits: 370
can't i make it disable...and other databases also...though he is not able to acess i want to make them disable..is it possible?
Post #1503389
Posted Thursday, October 10, 2013 1:45 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:17 AM
Points: 13,356, Visits: 10,215
$w@t (10/10/2013)
can't i make it disable...and other databases also...though he is not able to acess i want to make them disable..is it possible?


You can hide the databases if you really must. But not sure about the sa login.
You can always disable sa of course.

How to hide SQL Server user databases in SQL Server Management Studio




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1503398
Posted Thursday, October 10, 2013 4:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:24 PM
Points: 48, Visits: 370

THank you all..
how far is it secured..like if i give access with username to another client with public IP then does it safe for our data..??
how can i acheive high security in this process
Post #1503462
Posted Thursday, October 10, 2013 5:11 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:24 PM
Points: 48, Visits: 370
I am bit confusing on this process...


Can anyone clarify that i just want a user to see only one view in specific database..rest of all will be hide from user even systemdatabases ,logins ,another databases


Thanku you very much..
Post #1503470
Posted Thursday, October 10, 2013 5:16 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 6:20 AM
Points: 5,233, Visits: 9,481
Try it for yourself. Create a new login with the restricted permissions and log on as it. See what you can see and see what you can do. It may be that there are some objects that are always displayed and you just have to live with it. Bear in mind that the user will be able to see all objects that the public role has any permissions on.

John
Post #1503473
Posted Thursday, October 10, 2013 5:52 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:24 PM
Points: 48, Visits: 370
I have given required permission with these commands


 create login 'james' with password = 'xxx'
go

use MyDB
go

create user james for login james
go

grant select on [vw_paymen] t to james


after that

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..how can i restrict?? is it secured..??
Post #1503490
Posted Thursday, October 10, 2013 6:10 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 7:03 AM
Points: 832, Visits: 2,686
use master;
GO

DENY VIEW ANY DATABASE TO james





The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1503498
Posted Thursday, October 10, 2013 11:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:24 PM
Points: 48, Visits: 370
if i run above query then the user can not see any databases including the database which he has acces to only view
Post #1503867
Posted Thursday, October 10, 2013 11:19 PM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 5:57 PM
Points: 529, Visits: 1,568
I believe if you make this user Owner of the database that he should have access to, that overrides the deny view permission above and makes his database the only one visible, although that may give him more permissions on his database than you'd like.

Post #1503868
Posted Thursday, October 10, 2013 11:31 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 5, 2014 10:24 PM
Points: 48, Visits: 370
i want that user to just see only a view...if i make him as db_owner then he can do anything on database right??
but i don't want him to do anything other than select a view..
Post #1503870
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse