Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 user pemissions to access only a view

Author  Topic 

swathi3003
Starting Member

23 Posts

Posted - 2013-10-09 : 02:25:57
I need to give select permissions only for a view to user 'dhii' .he could not tables,sps,evn systemtables,security login, The view has columns from two tables from the same database (ABC). 'dhii' should only see the columns in this view, not update delete rtc

what are the steps to follow?

swathi3003
Starting Member

23 Posts

Posted - 2013-10-09 : 03:01:39
i have tried this

create login 'dhii' with password = ***
go

use SomeDb
go

create user 'dhii1' for login 'dhii'
go

grant select on vw_bill to dhii1
go

but i can see security(other users on db),systemtables,systemview etc

pls help me
Go to Top of Page
   

- Advertisement -