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.

Tablespace quotas

Tablespace quotas - Oracle Database Tutorial

From the course: Oracle Database 12c: Security

Start my 1-month free trial

Tablespace quotas

“

- [Instructor] In addition to granting system privileges we can also grant something known as tablespace permissions or quotas to various database users. Remember that tablespaces in the oracle database are logical storage groups that you create and these are made out of physical database data files that are used to store various objects in your Oracle Database such as tables or indexes. In order for users to be able and create objects inside those tablespaces, they need to be granted sufficient quotas or tablespace permissions. Let's see what happens when a user attempts to use space inside a database tablespace on which that user has no quota whatsoever. We will start by connecting using user1 to our orcl placable database. So I'll type sqlplus user1/secret@orcl. Now let's try and insert a new record into new_table. This is the table we've created in our previous video. So I'll type insert into new_table values one and hello. And as you can see we got an error telling us that this…

Contents