After creating the user and assigning permissions:
Use sqlplus
command line tools to access Oracle from the command line
sqlplus user/password <as sysdba|as sysoper> |
If your logged-in user is using ' sys ' you need to determine what SYSY permissions you want to use as SYSDBA or as Sysoper.
-
Creates a confluence user (for example, confluenceuser
) and gives the user only the following permissions:
create user <user> identified by <password> default tablespace <tablespace_name> Quota Unlimited on < Tablespace_name>; grant Connect to <user>; grant resource to <user>; grant create table to <user>; grant create sequence to <user>; grant create trigger to <user>; |
Confluence this requires that the user has the permissions described above. Confluence only requires these permissions on the above, so you need to assign specific permissions to the user. This user does not need to create tables, create sequences, and create triggers for these permission roles.
Do not give this user select any table
permission. This permission will cause problems with other schemas.
When you create a user, specify the Table object shown above tablespace
.
Https://www.cwiki.us/display/CONFLUENCEWIKI/Database+Setup+for+Oracle
Confluence 6 Oracle Create database user