Question: Explain Database Authorization
database authorization • 2.5k views
modified 16 days ago by gravatar for Sanket Shingote Sanket Shingote ♦♦ 290 written 2.9 years ago by gravatar for Anjali Sharma Anjali Sharma50

Authorization is finding out if the person once identified, is permitted to have the resource.

  • Authorization explains that what you can do and is handled through the DBMS unless external security procedures are available.

  • This is usually determined by finding out if that person is a part of a particular group, if that person has paid admission, or has a particular level of security clearance.

  • Authorization is equivalent to checking the guest list at an exclusive party or checking a ticket in an opera.

  • DBMS allows DBA to give different access rights to the users as per their requirement.

  • In SQL Authorization can be done by using Read, Insert, Update or Delete privileges.

  • Types of authorization: We can use any one or combinations of the following basic forms of authorization.

a) Resource Authorization:

  • Authorization to access any system resource

E.g: Sharing of database, Printers.

b) Alternation Authorization:

  • Authorization to add attributes or delete attributes from relations.

c) Drop Authorization:

  • Authorization to drop a relation.

Database administrator:

  • The main authority of databse system is databse administrator(DBA)

  • The SQL standard specifies modification to the schema can be done only by the database owner of schema or DBA of schema.

  • The DBA may authorize new users, restructure the database and so on.

  • It is analogous to that of superuser or operator for operating systems.  

written 2.9 years ago by gravatar for Anjali Sharma Anjali Sharma50
Please log in to add an answer.