What privileges are needed by the database user in Oracle to create objects?
The user needs connect and resource privileges. Create a separate tablespace for the user to use as its default tablespace if you don't want objects filling up any existing tablespaces. When testing is complete, you can drop cascade the user and drop the tablespace and your database will be back in the original state before testing.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center