I am creating an Oracle role with Admin option Grants so that user with this role assigned, will not be a full sysdba but will be able to create other users and grant them permissions.

What I hypothetically need would look like this - Grant grant tablespace to someRole

And I don't want use this GRANT SYSDBA TO myuser Thanks

  • I took a peek at the manual and it looks like CREATE USER system privilege gives you the ability to grant quota on tablespaces. So, they may just need create user. May 6 at 21:07
  • @BobbyDurrett This user in question has such privilege, I will try again. Thanks
    – T.S.
    May 6 at 21:16

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.