Power User Access to Certain Views Only (sql14)

Question

Good day,

I was told to give a specific business user access to DW Tables (sql14), i would like to give read access to specefic views only. (Not Tables)
Please Assist on how to go about it

Regards

Answer 1

Thank You, the user is using qlikview to connect
i dont have knowledge regarding qlikview but i want to limit as mush as possible.
I will select the deny option and see if user complains?

If using qlikview would i need to deny for linked server, is it only in ssms that user can view linked server.

thoughts please ?

Answer 2

-- Create a login
USE master;
GO
CREATE LOGIN [ReadOnlyUser] WITH PASSWORD = 'Strong_Password';
GO
-- Create a user for that login
USE [AdventureWorks2017];
GO
CREATE USER [ReadOnlyUser] FOR LOGIN [ReadOnlyUser];
GO
-- Grant a read-only permission on a specific view to the user
GRANT SELECT ON [HumanResources].[vEmployee] TO [ReadOnlyUser]
GO

Answer 3

Thank You,

I have a simlar script going, howver the user can see the linked servers & other databases even though theres no tabls to select
is there a way, the user logs in and only see the Views Folder?

Regards
strong text

Answer 4

You can say

DENY VIEW ANY DATABASE TO ThisUser

But in this case, the user will not find the database in Object Explorer directly, but first have to open a query window and move to the database.

Linked servers are not securables, so there is no way to hide them. But unless you have set up a proxy account that is common for all user, this user cannot make any use of the linked server.

Answer 5

Thank You very much All