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.
| Author |
Topic |
|
KilpAr
Yak Posting Veteran
80 Posts |
 Posted - 2012-11-14 : 02:28:37
|
| Is there a way to use a view as an user i.e. grant an access for a view to read a table? |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-11-14 : 06:57:40
|
You mean grant access to select from the view?GRANT SELECT ON dbo.YourView to TheUserNameOrRolename; |
 |
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-08 : 04:40:56
|
quote:
Originally posted by KilpAr
Is there a way to use a view as an user i.e. grant an access for a view to read a table?
we can only grant access to users of a database on its objects.users are created in order to access a database.Before a user can access the database, that particular user should be mapped to a login created for accessing instance.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
sgondesi
Posting Yak Master
200 Posts |
Posted - 2013-11-08 : 04:44:45
|
quote:
Originally posted by KilpAr
Is there a way to use a view as an user i.e. grant an access for a view to read a table?
or in other way.if the user in which you logged in has access to the table, then obviously the view which you are talking about can access that particular table.-- Thanks and RegardsSrikar Reddy Gondesi,BTECH-IT 2013 Passed Out,Trainee for SQL Server Administration,Miracle Software systems, Inc. |
|
|
|
|
|
|
Can I grant read-only access to table for view