How do I grant privileges on tablespace?

How do I grant privileges on tablespace?

Once connected as SYSTEM , simply issue the CREATE USER command to generate a new account.

1. CREATE USER books_admin IDENTIFIED BY MyPassword;
2. GRANT CONNECT TO books_admin;
3. GRANT CONNECT, RESOURCE, DBA TO books_admin;
4. GRANT CREATE SESSION GRANT ANY PRIVILEGE TO books_admin;
5. GRANT UNLIMITED TABLESPACE TO books_admin;

What is quota unlimited on tablespace?

To permit a user to use an unlimited amount of any tablespace in the database, grant the user the UNLIMITED TABLESPACE system privilege. This overrides all explicit tablespace quotas for the user. If you later revoke the privilege, then you must explicitly grant quotas to individual tablespaces.

How do I assign a temporary tablespace user?

ALTER USER DEFAULT TABLESPACE ; ALTER USER TEMPORARY TABLESPACE ; The user is assigned the default tablespace and temporary tablespace.

How to solve ora-01950 Oracle no privileges on tablespace?

ORA-01950: no privileges on tablespace “TABLESPACE_NAME” Cause: User does not have privileges to allocate an extent in the specified tablespace. Action: Grant the user the appropriate system privileges or grant the user space resource on the tablespace. You can give specific quota priviliges to user on tablespace as follows.

Why is there a no privileges on tablespace error?

The Oracle docs note this on the ora-01950 error: ORA-01950: no privileges on tablespace ” string ” Cause: User does not have privileges to allocate an extent in the specified tablespace. Action: Grant the user the appropriate system privileges or grant the user space resource on the tablespace.

What was the error in Oracle ora-01950?

“ORA-01950: no privileges on tablespace ‘SYSTEM’ ” : What error is it? SQL>create user suhail identified by password SQL>User created. SQL>Grant create session,create table to suhail; SQL>Grant Succeeded.

How to deal with ora-01950 in ITtoolbox?

Action: Grant the user the appropriate system privileges or grant the user space resource on the tablespace. On the ITtoolbox Forum, a confrontation concerning ORA-01950 has been posted. A replier offers information, by asking the user to solve ORA-01950 by either: