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