Grant Unlimited Quota On Tablespace To User. Web assign tablespace quotas to users. Web before granting the unlimited tablespace system privilege, you must consider the consequences of doing so.
Oracle Zephyr Enterprise Documentation
Alter user <<strong>user</strong>> quota unlimited on <tablespace name>; No privileges on tablespace 'users' i have done: Web if the user is going to be adding data or other objects, you need to grant the user tablespace quota in one of these ways: System privileges to users and roles. Web after a quota is assigned to nick for a particular tablespace, the total space used by all of his objects in that tablespace cannot exceed the quota. Grant unlimited tablespace privileges to a user. Web assign tablespace quotas to users. Grant the user unlimited tablespace. Sql> alter user dba_raj quota unlimited on temp ; Web create user sales quota 5m on data;
Web 1 answer sorted by: Now i have a critical. System privileges to users and roles. Alter user <<strong>user</strong>> quota unlimited on <tablespace name>; Web 12 i have a brand new oracle database that is giving the error: Web assign tablespace quotas to users. You don't want to grant the user. Web 24 managing users and resources this chapter describes how to control access to an oracle database, and contains the following topics: 1 you can only grant the unlimited tablespace privilege as a user that is allowed to grant it, such as the system user. Grant the user unlimited tablespace. Web create user sales quota 5m on data;
