Providing User Rights to User, to access only 1 View

Question

0.00/5 (No votes)

See more:

Dear Friends,

I need help with SQL User, I need to create 1 view and expose it for 3rd party application.

I have already created SQL view, and have also created User and provide the required permissions using 'select Grant ' statement.

But the problem is that when i connect SQL management studio through this user, i can't see tables (thats good) i can see only view. but when i run query ' select * from (table name)' it provides the result.

How can i provide secure user, so that the ResUser doesn't have any permissions other then accessing the particular view.

Please help. Thanks in advance.

P.S I am new to SQL, so please be kind :)

Posted 21-Jun-14 21:05pm

Amaan23

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jafarinejadvazifehkhorani · Accepted Answer · 2014-06-22T17:46:00

It seems that you haven't done it in a right way otherwise it must work,
please try the following scripts

USE [master]
GO
CREATE LOGIN [SomeTestUser] WITH PASSWORD=N'TestPAss', DEFAULT_DATABASE=[master], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO
USE [YourDatabase]
GO
CREATE USER [SomeTestUser] FOR LOGIN [SomeTestUser]
GO

and for giving permission for only select

SQL

USE YourDatabase
GO


GRANT SELECT ON YourView TO SomeTestUser

by following the way if the user wants to select other tables it will receive the following error :

The SELECT permission was denied on the object

for more info

http://www.blogs.lessthandot.com/index.php/DataMgmt/DBAdmin/MSSQLServerAdmin/giving-only-insert-permissions-to/[^]