From the course: Oracle Database 12c: Security

Unlock the full course today

Join today to access over 22,700 courses taught by industry experts or purchase this course individually.

Grant and evoke system privileges

Grant and evoke system privileges - Oracle Database Tutorial

From the course: Oracle Database 12c: Security

Start my 1-month free trial

Grant and evoke system privileges

“

- [Instructor] As you saw in the previous video, simply creating new Oracle database users is not enough, as these users have no permissions by default. They cannot even connect to the database. So, our next step would be to assign permissions to users using the Oracle grant command. With the grant command, we can both assign roles, which are groups of permissions, as well as individual permissions to perform certain actions and specific permissions on individual database objects. We'll see all of that in action in this video. So, let's start with something basic. Let's connect to our orcl pluggable database and grant the user1 user, which we created in our previous video, permissions to connect to the database. A good place to start. So, I'll type sqlplus sys/oracle at orcl as sysdba. Connecting with the sysdba superuser to our orcl pluggable database. And then type grant create session to user1. Create session is the special system privilege that allows a user to connect to the…

Contents