Accessing Features of Database to End User

Some of my friend ask me about there are some restrictions on accessing other features of DBMS on end users because he worked in an organization where all the features are not get accessed.

Every user in the database has a role which is defined by the Database Administrator. Users use features according to there needs, many features are restricted due to insufficient privileges because special permissions are needed.

Benefits of Database Privileges

  • Normal user can't delete your tables of harm your database.
  • No extra queries will deployed save traffic and load.
  • Nobody can seen the private data Except special peoples.
  • Maintenance of database can easily be handle.
  • Easy to access recent data and rollback.
  • Attacks and brute force attacks saved.
  • Easily banning and get back the privileges from Database Administrator.

Post a Comment