Oracle 12C and Bitbucket

• 
  Hi Christopher,
  Source Control for Oracle V4 supports Oracle 12c and Git repositories:
  
  https://documentation.red-gate.com/display/SOCO4/Requirements+and+supported+Oracle+versions
  
  https://documentation.red-gate.com/display/SOCO4/Supported+source+control+systems
  
  Many Thanks
  Eddie

  Eddie D August 30, 2017 12:27

  - 0 +
• 
  6

  2

  I have installed an Oracle 12c database on my system. I had an application which need to access the database.

  Previously in Oracle 11g, I used the following commands to create an user.

  create user name identified by name;  
  grant connect,create session,resource,create view to name;

  Can anyone tell me how to create a user in Oracle SOA 12c with my above requirements? I used the following statements but my installation is showing a fatal error saying

  FATAL ERROR - java.sql.SQLException: ORA-01950: no privileges on tablespace 'USERS'

  Following were the statements used.

  create user c##test1 identified by test1 container = ALL;
  grant connect,create session,resource,create view to test1

  nikjohn1538 January 08, 2019 06:16

  - 0 +
• 
  
  

  Hi nikjohn1538,
  
  I found when creating users in Oracle 12c that you need to specify the user's default tablespace using the commands below when creating the new user:

  
  

  DEFAULT TABLESPACE USERS QUOTA UNLIMITED|SIZE ON USERS;

  
  

  Using your example, setting the default tablespace with quota unlimited:

  
  

  create user c##test1 identified by test1 container = default tablespace USERS quota unlimited on USERS;

  
  

  Or setting a quota size:

  
  

  create user c##test1 identified by test1 container = default tablespace USERS quota 20M on USERS;

  
  

  Further reading available here:

  https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_8003.htm
  

  
  

  Many Thanks

  Eddie

  Eddie D January 08, 2019 10:28

  - 0 +

Add comment

Please sign in to leave a comment.