Account A can retrieve or modify any relation except DEPENDENT and can grant any of these privileges to other users. (b) Account B can retrieve all the attributes of EMPLOYEE and DEPARTMENT except for SALARY, MGRSSN, and MGRSTARTDATE. (c) Account C can retrieve or modify WORKS_ON but can only retrieve the FNAME, MINIT, LNAME, SSN attributes of EMPLOYEE and the PNAME, PNUMBER attributes of PROJECT. (d) Account D can retrieve any attribute of EMPLOYEE or DEPENDENT and can modify DEPENDENT. (e) Account E can retrieve any attribute of EMPLOYEE but only for EMPLOYEE tuples that have DNO = 3. (f) Write SQL statements to grant these privileges. Use views were appropriate

Question

ahmedgalal20204 ahmedgalal20204

07-11-2022
Computers and Technology

Answered

Get the answers you need at Westonci.ca, where our expert community is dedicated to providing you with accurate information. Explore thousands of questions and answers from knowledgeable experts in various fields on our Q&A platform. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

Account A can retrieve or modify any relation except DEPENDENT and can grant any of these privileges to other users. (b) Account B can retrieve all the attributes of EMPLOYEE and DEPARTMENT except for SALARY, MGRSSN, and MGRSTARTDATE. (c) Account C can retrieve or modify WORKS_ON but can only retrieve the FNAME, MINIT, LNAME, SSN attributes of EMPLOYEE and the PNAME, PNUMBER attributes of PROJECT. (d) Account D can retrieve any attribute of EMPLOYEE or DEPENDENT and can modify DEPENDENT. (e) Account E can retrieve any attribute of EMPLOYEE but only for EMPLOYEE tuples that have DNO = 3. (f) Write SQL statements to grant these privileges. Use views were appropriate

Sagot :

Thank you for your visit. We're committed to providing you with the best information available. Return anytime for more. We appreciate your time. Please come back anytime for the latest information and answers to your questions. Thank you for visiting Westonci.ca. Stay informed by coming back for more detailed answers.

Single-celled organisms are called____.

Which aspect is most important when comparing different desktop configurations for a software development environment?A) The physical size of the monitor.B) The

Chevron placed an ad with copy reading, "Protecting the planet is everyone’s job. We Agree," that encouraged consumers to use renewable energy. Which type of ad

How many states and the District of Columbia prohibit employment discrimination on the basis of sexual orientation? A. 38 B. 14 C. 45 D. 21

25 Se desea construir un recipiente rectangular sin tapa como el de la imagen. Las caras laterales serán de acrílico color verde, cuyo costo del material es de

Which medication was likely prescribed to a male patient with enlarged breasts who has been receiving treatment for gastroesophageal reflux disease? a. Sucralfa

8. How do you format cells in a spreadsheet to change the appearance of the data?

Which three structural issues did the second wave of the Women's Movement work to address?A. Barriers to employment, such as ads saying only men could apply.B.

Understanding human factors is best done through the discipline of criminology.A. TrueB. False

The table below shows the typical hours worked by employees at a company. A salaried employee makes [tex]\$ 78,000[/tex] per year. Hourly employees get paid [te

Sagot :

Other Questions