6 Replies Latest reply: Feb 21, 2013 6:55 AM by salute-Salem RSS

    priviliges issue

    salute-Salem
      hi all, db and dev 10g rel2
      , how to make a user sees another user objects , what is the priviliges i should pass to him to do the task ,
      i mean
      i want scott user to see the hr objects and do anything on it , insert,update,delete , create and drop anything ,...........?

      thanks in advance
        • 1. Re: priviliges issue
          HamidHelal
          semsem wrote:
          hi all, db and dev 10g rel2
          , how to make a user sees another user objects , what is the priviliges i should pass to him to do the task ,
          i mean
          i want scott user to see the hr objects and do anything on it , insert,update,delete , create and drop anything ,...........?

          thanks in advance
          check this
          1. http://docs.oracle.com/cd/B10500_01/server.920/a96521/privs.htm
          2. http://docs.oracle.com/javadb/10.8.2.2/ref/rrefsqljgrant.html

          Hope this helps
          • 2. Re: priviliges issue
            870213
            check this link

            http://www.techonthenet.com/oracle/grant_revoke.php
            • 3. Re: priviliges issue
              salute-Salem
              i know about privileges , but i want only this part which i do not know ?
              • 4. Re: priviliges issue
                HamidHelal
                semsem wrote:
                i know about privileges , but i want only this part which i do not know ?
                if you know that then you also know
                as user admin or hr
                GRANT SELECT ON hr.table_name TO scott;
                GRANT update ON hr.table_name TO scott;
                Do you want someone to create script for you ?

                Hamid
                • 5. Re: priviliges issue
                  Christian Erlinger
                  Creating Tables in another schema:
                  http://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_7002.htm#i2235043

                  the same works with procedures etc.

                  granting privileges on objects:
                  http://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_9013.htm#i2094944

                  as you can see this is all well documented, please go through the documentation yourself instead asking us to abstract it for you.

                  And just for the record: create any table is a very powerful privilege to grant to a user; I'd think twice or more often about if you really need that.

                  cheers
                  • 6. Re: priviliges issue
                    salute-Salem
                    i am so sorry , you were right , it 's my mistake , thanks a lot