what is the difference between securityand protection in dbms?

Answer Posted / pari

Data security is the protection of the database from unauthorized users. Only the authorized persons are allowed to access the database. Most of the users are allowed to access a part of database i.e., the data that is related to them or related to their department. Mostly, the DBA or head of department can access all the data in the database. Some users may be permitted only to retrieve data, whereas others are allowed to retrieve as well as to update data. The database access is controlled by the DBA. He creates the-accounts of users and gives rights to access the database. Typically, users or group of users are given usernames protected by passwords.

Most of the DBMSs provide the security sub-system, which the DBA uses to create accounts of users and to specify account restrictions. The user enters his/her account number (or user name) and password to access the data from database. For example, if you have an account in the "hotmail.com" (a popular website), then you have to give your correct username and password to access your account of e-mail. Similarly, when you insert your ATM card into the auto teller machine (ATM) in a bank, the machine reads your ID number printed on the card and then asks you to enter your pin code (or password). In this way you can access your account..

Is This Answer Correct ?    5 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the features of rdbms?

481


What is entity and its types?

507


What is limit in dbms?

479


What are the different types of database?

498


Define atomicity and aggregation.

557






What is advantage of dbms?

558


What are the different types of DBMS architecture?

547


What is raid controller technology?

518


What are the examples of database?

481


What are the different types of modeling?

508


Who is the founder of database?

486


What are database modules?

507


What do you understand by join?

540


What are database functions?

465


Explain the use of assign statement in progress database?

532