CODEWITHSUNDEEP
schemaoracle11goracle-sqldeveloper
rynmrtn
rynmrtn

Reputation: 3419

Oracle setup database to share schema

I am looking for the best way to setup an Oracle database so that multiple roles can share a single schema with tables.

I would have, for example, several roles:

I have been able to create groups, grant privileges to other schemas, and create a logon trigger to switch the schema on logon. However, users are not able to view tables through SQL Developer.

Upvotes: 1

Views: 527

Answers (1)

Justin Cave
Justin Cave

Reputation: 231651

SQL Developer will only show the objects owned by the current user, not those that are owned by the session's current_schema setting, in the tree view unless you go to Other Users and choose the schema you're interested in. In order to see objects owned by other users, you're realistically going to have to navigate to the appropriate schema. If there are a large number of schemas in the database, you can right click on Other Users and create a filter that limits the set of users that are returned to just the schema you care about.

Upvotes: 1

Related Questions