Database administrator:

• The main authority of database system is database 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.

• 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:

• Any one or combinations of the following basic forms of authorization can be used by the Administrator

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 database system is database 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.

• 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:

• Any one or combinations of the following basic forms of authorization can be used by the Administrator

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.