开发者

How to create schema that have an access as that of dbo and can be accessed by sa user

开发者 https://www.devze.com 2023-01-03 04:48 出处:网络
I am new to schema, roles and user management part in sql server. Till now I used to work with simple dbo schema but now after reading few articles I am intrested in creating schema for managing my ta

I am new to schema, roles and user management part in sql server. Till now I used to work with simple dbo schema but now after reading few articles I am intrested in creating schema for managing my tables in a folder fashion.

At present, I want to create a schema where i want to keep my tables that have same kind of functionality. When I tries to cr开发者_高级运维eate a schema then I faces a problem while using query, permissions etc.

First of all i want to get used to of using schemas then only I want to explore it. But due to initial stages and work pressure as well i m not able to implement it yet.

What can i do to start using schema with default permissions as that of dbo. Also let me know about creating roles and assigning roles on these schema. I want all this to be accessible by sa user itself at present.

What is the concept behind all these things


Basically

  • The schema has an owner
  • Objects in different schemas can access each other with no extra permissions if they have the same owner

Please see my question here: "SQL Server: How to permission schemas?" and RBarryYoung's enlightening answer...

0

精彩评论

暂无评论...
验证码 换一张
取 消