SYSDBA has no problem connecting, but due to organisational constraints, we require an account without full SYSDBA privileges.
I've seen references to "obscure" privileges needed to connect to an RDF database from Protege. The two (very) old references I found were:
- grant query rewrite to the account.
- grant CREATE_INEXTYPE to the account
Unfortunately I'm still getting "insufficient privileges" and there is nothing on the Protege side to indicate a specific error.
The following should suffice.
grant connect, resource to <your_user>;
You may also want to run:
grant connect, resource, unlimited tablespace to <your_user>;
Hope it helps,