written 6.1 years ago by |
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.
written 6.1 years ago by |
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.