Database AdministrationTU Board 2079
What is the importance of privileges in database security? Explain about role in oracle datanse and write command to do following: a. Create role b. Grant system and object privileges to role c.…
10What is the importance of privileges in database security? Explain about role in oracle datanse and write command to do following: a. Create role b. Grant system and object privileges to role c. Create user d. Assign role to user e. Drop role
A worked answer is on its wayMeanwhile, read the Database Administration notes for this topic.
Discussion
Loading…
More Database Administration questions
What are different database administration tasks? Explain Oracle Data Guard in brief.TU Board 208110What is initialization parameter file? Differentiate between Spfile and Pfile. Explain some oracle defined roles with suitable example.TU Board 208110What is Tablespace? What is UNDO RETENTION Policy? Write different commands to manage the tablespaces in Oracle.TU Board 208110What is privilege? Write commands to create user, grant privilege, revoke privilege and drop user in oracle database.TU Board 20815What is Oracle AWR? How AWR report is viewed in oracle?TU Board 20815What is Data Pump? Explain the procedure of exporting and importing data using Oracle Data Pump.TU Board 20815