kinkajou
Reputation: 3728
How to grant access to role in SQL server 2008 only some schema?
I have roles created in sql server. How to grant access to only certain schema to roles?
Upvotes: 0
Views: 775
Answers (1)
stb
Reputation: 3513
click on Properties of your Role and go to User Mapping. There you can grant access for every schema
Upvotes: 1
Related Questions
- How can I make a SQL Server schema accessible to only one role?
- How to grant access to multiple schemas in one go in SQL Server
- grant role to schema
- SQL Server: How to permission schemas?
- Grant security permissions to a database role
- SQL Server 2008 - give user access to certain tables and views only
- Multiple Schema Permissions In SQL Server 2008 R2
- Schema Permissions in SQL Server 2008 R2
- how to grant role acces to specific schema
- How to restrict a user to access objects of only one schema in SQL Server 2008?