Database Security in SQL Server – SQL Server Tutorial

DATABASE SECURITY  :-

The different facilities in SQL Server to provide security :-

1. Logins  and users
2. Great & revoke commands
3. Views.

(I) Logins & users  :-

Creating logins :-

In sql server the users are two types  :

1. Window user
2. Sql Server user

(i) Creating windows user :-

• Open control panel
•               ↓
• Open user accounts
•                 ↓
• click create a new A/C – option
•                 ↓
• Enter user name
•                 ↓
• Click next
•                 ↓
•  Select limited
•                 ↓
• Click create A/C button

If this user wants to connect to sql server,then first the user has login to the operating system & open sql server & select window Authentication.

(2)  SQL SERVER   :-

Only system adminstrator[sa] is having permission to create logins & users
to create a new login,

•               In object explorer
•                         ↓
•               Select properties
•                          ↓
•               Select server roles
•                           ↓
•                And select system admin

Creating Users  :-

After connecting to sql server to access database are user must created in th database.
Only sa can create users.

• To create a user,expanded database.
•           ↓
•  Expanding  searify folder,
•            ↓
• Select users
•             ↓
•  Select new user
•              ↓
• Give user name:NSI
•               ↓
•  Login name :scott
•                ↓
•    Click   ok

Select user_name ( ).
To give the permission to user,so

•       Select the User
•           ↓
• Right click select properties

•            ↓
• Database role membership
•            ↓
• Select the permission given to user
•            ↓
• Click ok

Example:  Db_ddladmsn

                          ↓

                         Ok