Hi. Connect as sys or system to your PDB, grant CONNECT and RESOURCE privileges to user.
grant connect, resource to user;
Great! That worked, except that I can only create tables. I did the GRANT CREATE TABLE to <user>. But now the query now throws an error on the INSERT INTO command: You can tell I'm really new at this, but I have gotten this far! Thanks to your help! Should I GRANT ALL???? I tried GRANT Insert into table. Didn't like that! Must not be a role or privilege.
Error starting at line : 41 in command -
INSERT INTO GUIDE
('AM01','Abrams','Miles','54 Quest Ave.','Williamsburg','MA','01096','617-555-6032','6-3-2012')
Error report -
ORA-01950: no privileges on tablespace 'USERS'
connect as sys or system to your database and execute
ALTER USER <USER> QUOTA UNLIMITED ON USERS;
Between both of you, I got it to work!!!!
Thank you both so much. I fought this for 10 to 12 hours a day for 11 days.
Now to give "correct answer" to both of you. I'll try.
glad to hear that your issue is solved.
Two books of the Oracle Documentation may be helpful for you:
- 2 Day DBA: https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/index.html
- 2 Day Developer's Guide: https://docs.oracle.com/en/database/oracle/oracle-database/19/tdddg/index.html
The topic "User Creation & User Privileges" is covered in https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/administering-user-accounts-and-security.html#GUID-190C93F1-B4CD-4E88-836F-CCD79AA910CD