Message ORA-01952: system privileges not granted to |
Cause of Error When you revoke the RESOURCE or DBA role from a user, the UNLIMITED TABLESPACE system privilege is automatically revoked. You receive the error message because the Oracle Security Manager also tries to revoke the UNLIMITED TABLESPACE system privilege, which results in the same privilege being revoked twice. |
Solution Summary Click 'OK', and then ignore the error message because the roles and the privileges have already been revoked successfully. To avoid the error message, revoke the UNLIMITED TABLESPACE system privilege before you revoke the RESOURCE or DBA role. |
Solution Details  NOTE: This procedure assumes that you have sufficient account privileges to access the appropriate database and to modify user accounts. To revoke the UNLIMITED TABLESPACE system privilege before you revoke the RESOURCE or DBA role: 1) If you have not already done so, start Oracle Security Manager, and then log on to the appropriate database. 2) Click the plus sign to expand the Users folder. 3) Click the name of the user you want to revoke the UNLIMITED TABLESPACE system privilege from, and then click the 'Roles/Privileges' tab. 4) In the 'Privilege Type' box, click 'System Privileges'.  'Privilege Type' box5) Under 'Granted', double-click 'UNLIMITED TABLESPACE' to revoke the system privilege. 6) Click 'Apply'. 7) Revoke the RESOURCE or DBA role. |
Applies to Software Version Oracle8 Security Manager |
Error: ORA-01952: system privileges not granted to (when revoking DBA).
