3 Replies Latest reply on Feb 26, 2015 6:19 PM by thatJeffSmith-Oracle

    Can anyone please guide me to the right forum for users creation in SQL?

    user626836

      Hi everyone,

      1) I have logged in Oracle as administrator and created a user table owner with this steps:

      CREATE USER user_name
      IDENTIFIED BY password
      DEFAULT TABLESPACE USERS
      TEMPORARY TABLESPACE TEMP
      PROFILE DEFAULT
      ACCOUNT UNLOCK;

      2) Then I gave the following permission to the user:

      GRANT CONNECT TO user_name;

      3) Then I gave resources to the user:

      GRANT RESOURCE TO user_name;

      4) Then I connected to the user, created all the tables and put all the needed information inside of each table.

      5) After that I logged again as administrator and created another user who is going to be changing, inserting and selecting the data.

      6) Then I connected to the table owner and granted permission to the user to see all data inside the tables like this:

      GRANT SELECT,INSERT,UPDATE,DELETE ON table1 TO user_name;

      7) When the user connects he receive an error saying table does not exists.

      Can anyone please help and show me where I made a mistake here?