Name the DCL ( table. idently given permissions to delete records from the Customer table. Write...

Question

Question

Name the DCL ( table. idently given permissions to delete records from the Customer table. Write control language) statement such that Bob cannot delete records from Customer Data A university has two tables, Student and Alumni, ALUMNI Table Attribute DENT Table ibute ntiD Data Type INTEGER(8,0 VARCU ntName

engineering Computer-Science

Add a comment Improve this question Transcribed image text

Answer 1

Answer #1

Please find my naswer.

REVOKE DELETE
ON CUSTOMER
FROM Bob

The Syntax for the REVOKE command is:

REVOKE privilege_name
ON object_name
FROM {user_name |PUBLIC |role_name}

Add a comment

Answer 2

Similar Homework Help Questions

rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name...

rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name varchar(25) student last name major_id integer the ID of the student's major; a foreign key for the major_id in the rider_major table rider_major Column Data Type Description major_id integer the primary key major_name varchar(50) student first name major_description varchar(100) student last name Use the Tables above to answer the questions. Questions: 1. Write a SQL statement to add a student record to the rider_student...
JAVA Write code to define a Customer class, which has id and name attributes of String...

JAVA Write code to define a Customer class, which has id and name attributes of String data type and points attribute of integer data type, without breaking encapsulation.
use workbench please Task 1: Create a database and name it practical2DB. (2 marks) Task 2:...

use workbench please Task 1: Create a database and name it practical2DB. (2 marks) Task 2: Create all the four tables according to the relational scheme in Figure 1. (8 marks) Task 3: Insert 5 records to into each table. (5 marks) Task 4: Write a query to list alphabetically ordered names, addresses, and IDs of all the customers whose postcode is in (40150, 40400, 47500). (10 marks) Task 5: Delete 1 record from Products table using their primary keys....

Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accoun...

Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accounting, and employee data, and these different data sets must all be efficiently managed in order to make the data accessible. Companies rely on database engineers to ensure that their records are accurate, updated, and tracked in real time. This course covers structured query language (SQL) and how it can be used to manage database schemas, manipulate data, and analyze data. For your final...
Write the SQL statement to select records from a table called CUSTOMER_INFO that returns the customer's...

Write the SQL statement to select records from a table called CUSTOMER_INFO that returns the customer's first name, last name, area code and phone number (you can make up field names). Only return records that have a Stephenville area code (254).
Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName,...

Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName, income, birthDate} Account = {accNumber, type, balance, branchNumberFK-Branch} Owns = {customerIDFK-Customer, accNumberFK-Account} Transactions = {transNumber, accNumberFK-Account, amount} Employee = {sin, firstName, lastName, salary, branchNumberFK-Branch} Branch = {branchNumber, branchName, managerSINFK-Employee, budget} Focus should be on using: Order By to sort data Set Operators to union/intersect multiple tables Join Operator to join multiple tables Aggregations and Group By to aggregate data Subqueries 3.8 SIN, first name,...

4. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you change the FacultyName field from 25 characters

Problems and Exercises 1 through 9 are based on the dass scheduling 3NF relations along with some sample data shown in Figure 6-11. Not shown in this figure are data for an ASSIGNMENT relation, which represents a many-to-many relationship between faculty and sections.4. Write SQL data definition commands for each of the following queries:a. How would you add an attribute, Class, to the Student table?b. How would you remove the Registration table?c. How would you change the FacultyName field from...
Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName,...

Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName, income, birthDate} Account = {accNumber, type, balance, branchNumberFK-Branch} Owns = {customerIDFK-Customer, accNumberFK-Account} Transactions = {transNumber, accNumberFK-Account, amount} Employee = {sin, firstName, lastName, salary, branchNumberFK-Branch} Branch = {branchNumber, branchName, managerSINFK-Employee, budget} Focus should be on using: Order By to sort data Set Operators to union/intersect multiple tables Join Operator to join multiple tables Aggregations and Group By to aggregate data Subqueries 3.15 Customer ID, first...
Write a Java program to read customer details from an input text file corresponding to problem...

Write a Java program to read customer details from an input text file corresponding to problem under PA07/Q1, Movie Ticketing System The input text file i.e. customers.txt has customer details in the following format: A sample data line is provided below. “John Doe”, 1234, “Movie 1”, 12.99, 1.99, 2.15, 13.99 Customer Name Member ID Movie Name Ticket Cost Total Discount Sales Tax Net Movie Ticket Cost Note: if a customer is non-member, then the corresponding memberID field is empty in...

gender) in HDFS, write a MapReduce Given a 10TB table Student (name, year, program to compute the following query. gpa, SELECTyear, AVG (gpa) FROM WHERE GROUP BY year Student gender'Male' Ans...

gender) in HDFS, write a MapReduce Given a 10TB table Student (name, year, program to compute the following query. gpa, SELECTyear, AVG (gpa) FROM WHERE GROUP BY year Student gender'Male' Answer gender) in HDFS, write a MapReduce Given a 10TB table Student (name, year, program to compute the following query. gpa, SELECTyear, AVG (gpa) FROM WHERE GROUP BY year Student gender'Male' Answer

Name the DCL ( table. idently given permissions to delete records from the Customer table. Write...

Homework Answers

Add Answer to:
Name the DCL ( table. idently given permissions to delete records from the Customer table. Write...

Post as a guest

Earn Coins

rider_student Column Data Type Description student_id integer the primary key first_name varchar(25) student first name last_name...

JAVA Write code to define a Customer class, which has id and name attributes of String...

use workbench please Task 1: Create a database and name it practical2DB. (2 marks) Task 2:...

Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accoun...

Write the SQL statement to select records from a table called CUSTOMER_INFO that returns the customer's...

Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName,...

4. Write SQL data definition commands for each of the following queries: a. How would you add an attribute, Class, to the Student table? b. How would you remove the Registration table? c. How would you change the FacultyName field from 25 characters

Write following queries given these schemas: (FK stands for Foreign Key) Customer = {customerID, firstName, lastName,...

Write a Java program to read customer details from an input text file corresponding to problem...

gender) in HDFS, write a MapReduce Given a 10TB table Student (name, year, program to compute the following query. gpa, SELECTyear, AVG (gpa) FROM WHERE GROUP BY year Student gender'Male' Ans...

Name the DCL ( table. idently given permissions to delete records from the Customer table. Write...

Homework Answers

Add Answer to: Name the DCL ( table. idently given permissions to delete records from the Customer table. Write...

Post as a guest

Earn Coins

Add Answer to:
Name the DCL ( table. idently given permissions to delete records from the Customer table. Write...