Search code examples
sqloracle10gprivileges

Where to store the tables to grant privilege to a new user in oracle 10g

I am working an assignment project for university. Where I have four users admin, user, organizer and sponsor.

Now I don't want "ALL" privileges to all users. For example I want to set only select privilege to organizer for table FEST.

I know how to grant privilege to user from the SYSTEM user in oracle 10g. But I'm confused where to store the tables like FEST. Should I store under the user SYSTEM or organizer?

Solution

  • A table that is created is already stored in the database.

    If you are looking to store the table_name for the purpose of tracking, which user was granted which privilege on which table, that is also available in data dictionary views.

    If you are looking for something else, kindly be more specific.

    Thanks.