To set the DBO schema for a SQL Server server

Source: Internet
Author: User

The server login name , which is the user who has permission to log on to a server;

server Role , a fixed set of server users, the default is 9 groups;

    • Logins must belong to some roles, default to public

    • Server roles are not allowed to change

    • Does not necessarily have permission to manipulate the database after logging on

database user , refers to the user who has permission to operate the database;

A database role , which is a fixed set of database roles with certain permissions;

database schema , which refers to the container of database objects;

    • The database user corresponds to the server login so that the logged-on person can manipulate the database

    • Database roles can be added and different permissions can be customized

    • Database schemas, similar to the namespace of database objects, where users Access database objects through schemas

And by allowing these concepts to be clear:

    

The above content is reproduced in sima2004 's Blog

First step: Create a new login name

Part II: Creating a new Database

Step Three: Mydb-->security-->schema-->new Schema

Fourth Step: Mydb-->security-->users-->new User

Fifth step: Set the user mapping of the login name

Log in with the new login mas, create the table Taba,

According to the above method, new schema Schema2, login name mas2, user name User2

Log in with the new login name MAS2 to create the table Taba.

Dbo. Taba is created by the sa login name

Myschema.taba is created with the MAS login name

Myschema2.taba is created by the MAS2 login name

To set the DBO schema for a SQL Server server

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.