From the course: Oracle Database 12c: Security
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Object permissions - Oracle Database Tutorial
From the course: Oracle Database 12c: Security
Object permissions
- [Lecturer] For each object created in the Oracle database you can assign or grant permissions. For example, you can grant specific database users the capability to interact with specific database objects, such as selecting data from tables or executing stored procedures. Lets see a quick example of Oracle object permissions in action. We will start by connecting to our ORC pluggable database as the sysdba user. So type sqlplus sys/oracle@orcl as sysdba. Let's also grant user two, which is the user we created earlier in our chapter the ability to create procedures, create views and create tables. So I'll type grant create procedure, create view, create table to, and the user name, user2 in our case. Now let's click our sql dot session and reconnect to the database using this user two local user. So I'll type quit; And sqlplus user2/secret@orcl. I'm now connected to the ORCL pluggable database as user two. Now let's create a new table and insert some rows into it. You can find the…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
Users, schemas, and the SYSDBA5m
-
(Locked)
Create new database users6m 34s
-
(Locked)
Grant and evoke system privileges8m 4s
-
(Locked)
Grant database-wide system privileges6m 2s
-
(Locked)
Tablespace quotas5m 37s
-
(Locked)
Object permissions7m 39s
-
(Locked)
Password management policies7m 50s
-
(Locked)
The WITH GRANT and WITH ADMIN options3m 14s
-
(Locked)
Enforce password complexity6m 13s
-
(Locked)
Viewing users, permissions, and polices7m 32s
-
(Locked)
Deleting a database user4m 48s
-
(Locked)
Local vs. common user concepts2m 49s
-
(Locked)
Creating local users6m 45s
-
(Locked)
Creating common users7m 1s
-
(Locked)
Separating object owners and access5m 34s
-
-
-
-
-