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.
Grant database-wide system privileges - Oracle Database Tutorial
From the course: Oracle Database 12c: Security
Grant database-wide system privileges
- [Instructor] In addition to the system privileges we described and demoed in our previous video, there is also a special type of system privilege known as the any privilege. If you remember from our previous video, when you want to give a user the permission to create a specific database object such as a database table, you grant the create table privilege to that user. This privilege will give the user the ability to create tables in their own schema, that is tables which will be owned by the user who created them. However, granting the create any table permission to a database user will allow that user to create tables in any database schema. Let's see the any permission in action. For our demo, let's connect to the orcl placable database as the sys superuser and create a second database user, calling it user2. So I'll type sqlplus sys/oracle@orcl as sysdba opening a superuser sys dba connection to our orcl placable database. We'll now create this user2 database user by typing…
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
-
Create new database users6m 34s
-
Grant and evoke system privileges8m 4s
-
Grant database-wide system privileges6m 2s
-
Tablespace quotas5m 37s
-
Object permissions7m 39s
-
Password management policies7m 50s
-
The WITH GRANT and WITH ADMIN options3m 14s
-
Enforce password complexity6m 13s
-
Viewing users, permissions, and polices7m 32s
-
Deleting a database user4m 48s
-
Local vs. common user concepts2m 49s
-
Creating local users6m 45s
-
Creating common users7m 1s
-
Separating object owners and access5m 34s
-
-
-
-
-