How to restrict access to only a certain view
Hi everybody:
I wanted to know how can I restrict access to my sql server 2005 database so that a login can only query a view. I have about 5 views created and I want a developer to only be able to query and create his app from those views. I don't want them to be able to access anything else in the database just those views. thank you for any help.
I wanted to know how can I restrict access to my sql server 2005 database so that a login can only query a view. I have about 5 views created and I want a developer to only be able to query and create his app from those views. I don't want them to be able to access anything else in the database just those views. thank you for any help.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
First, open the Database.
Second, Click on + to open Views
Third, Right mouse click on the view and select "Properties"
Fourth, Click on "Permissions" and it will show the Permission Panel.
Fifth, Click on the "Grant" in the Select option.
Second, Click on + to open Views
Third, Right mouse click on the view and select "Properties"
Fourth, Click on "Permissions" and it will show the Permission Panel.
Fifth, Click on the "Grant" in the Select option.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
60MXG, will this restrict them from the other objects in the db
yeah!
ASKER
thanks guys that help me a lot.
Microsoft SQL Server 2005
Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.
72K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
can you explain this in a little more detail to me.