user pemissions to access only a view

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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources