|
Home
|
Sign up!
|
Projects
|
Seminars
|
Research Notes
|
Today's Lecture
|
About
|
Update Research Note Form
Course:
Research Note Topic:
Research Note Description:
In DBMS, DBA (Data Base Administrator) is the central authority for managing a data base systems. The data base administrator’s includes granting privileges to user who needs to use the system and classify user and data in accordance with the policy of the organization . This is known as
AUTHORIZATION.
Authorization is a process that includes all the techniques for protecting the database against persons who are not authorize to access either certain part of the database or the whole database.
DBA privileged commands include commands for granting and revoking privileges to individual account, user or groups and for performing the following types of action.
Account creation:
This creates a new account and password for a user to access Data Base.
SYNTAX ….
GRANT USAGE on *.* TO username@localhost identified by password;
Eg. Grant usage on *.* to sanjay@localhost identified by sanjay;
Privilege granting:
This action permits the DBA to grant certain privileges to certain accounts.
SYNYAX …
GRANT queries ON TABLENAME to USERNAME;
Eg. Grant SELECT, DELETE, UPDATE on sanjayshop to Ankit;
(By this Ankit can only update, delete, select in my database).
Privileges revocation:
This action permits DBA to revoke (cancel) certain privileges that were previously given to certain accounts.
SYNTAX …
REVOKE queries ON TABLENAME to USERNAME;
Eg. REVOKE DELETE, UPDATE on sanjayshop to Ankit;
(By this now Ankit can only select in my database.because I cancelled his power for delete and update).
Note : Here queries meant that which function do you want to allow to the user to access Database.
Your Password:
Prof. Ashay Dharwadker