Question

topic:- Fundamentals of Databases

*********** no hand writing*********

If there is photo but photo don’t do fax ?

*the answer must be unique not copied "plagiarized "

question One

Consider the following two tables:

Table – EmployeeInformations

EmpId Name ManagerId DateOfJoining

121 Ali 321 01/31/2014

321 Raed 986 01/30/2015

421 Khaled 876 27/11/2016

Table – EmployeeSalary

EmpId Project Salary

121 P1 8000

321 P2 1000

421 P1 12000

Question

Explain the role of SQL authorization mechanisms that allow to differentiate among the users of the database as far as the type of access they are permitted on various data values in the database?

Answer 1

Authorization refers to providing permission to someone to perform a particular task. When it comes to SQL there are certain authorization mechanisms that take care of the permissions given to the users of a database according to their designations and requirements.

In SQL this is taken care of through SQL standard authorization mode which is an access control system and is compatible with SQL 2003. This can be enabled in the Derby DBMS by setting the derby.database.sqlAuthorization property to true. Derby is given as the reference as it has the most simple database access mode which can be used to provide users with full, read-only, or no-access authorization.

When a table, function, procedure or view is created, the person who creates the object is known as the owner of the object. Only the object owner or the database owner has full privileges on this object. Other users can only be granted database privileges by the object owner be it public or an individual privilege. Only the project owner has granting or revoking rights associated with database privileges.

Once the SQL standard authorization mode is enabled, the object owner can use Grant or Revoke statements to set the user privileges for specific database operations such as Insert, Update, Select, etc or on some database objects such as views or tables. Roles can also be used by the object owners to administer the database privileges.

Here's the solution to your problem. Thanks for asking and happy learning!!!!