Database AdministrationModel question
Write the commands to create a role having any two privileges and create a user and assign above role to the specified user.
5A worked answer is on its wayMeanwhile, read the Database Administration notes for this topic.
Discussion
Loading…
More Database Administration questions
What is multiplexing? Why is it needed? Write the steps of multiplexing the redo log files and control files with oracle commands.Model question10Explain the term backup, restore and recovery in oracle database. As a DBA of an organization, explain your backup policy (guideline) of your database and…Model question10What do you mean by database management system? Mention the clear architecture of oracle database management system including different files.Model question10Explain the term Database administrator (DBA) and describe the different roles of DBA.Model question5What is the importance of privileges in database security? Explain the different system and object privileges used in ORACLE database with example.Model question5What is indexing? Why is it important? Explain it with example.Model question5