Tag: databases

Backup and Recovery

Transactions

Security

Queries

What is this customer’s address?

Does this customer have any unpaid bills?

What is the balance in this customer’s account?

What is the total sales for each of the last 6 months?

Current

Projected

Historical

Current and Projected

Design Advisor

Visual Explain

Performance Advisor

Configuration Assistant

SERVER

SERVER_ENCRYPT

CLIENT

DCS

Encrypt the table's data

Create a view that does not contain the AVG_SALARY column

Revoke SELECT access for the AVG_SALARY column from users who should not see AVG_SALARY data

Store AVG_SALARY data in a separate table and grant SELECT privilege for that table to the appropriate users

CREATEIN privilege on the database

REFERENCES privilege on TAB1 and TAB2

CREATE_TAB privilege on the database

SELECT privilege on TAB1 and TAB2

Drop an index on the EMPLOYEE table

Grant all privileges on the EMPLOYEE table to other users

Alter the table definition

Drop the EMPLOYEE table

CALL privilege on the procedure; SELECT privilege on the table

CALL privilege on the procedure; REFERENCES privilege on the table

EXECUTE privilege on the procedure; SELECT privilege on the table

EXECUTE privilege on the procedure; REFERENCES privilege on the table

DELETE privilege on the table

DELETE privilege on the alias

DELETE privilege on the alias; REFERENCES privilege on the table

REFERENCES privilege on the alias; DELETE privilege on the table