Subashini.Ramasamy

 Profile Answers by Subashini.Ramasamy Questions by Subashini.Ramasamy

• Feb 26th, 2007

 

 Hi Friends,


           You can follow this one for granting all permission of one user to another.

  GRANT ALL ON <TABLE-NAME> TO <USER-NAME> [WITH GRANT OPTION]
   
            
      ALL                   used to specify all of the object privilegs such as      
                              ALTER,DELETE,INDEX,UPDATE,INSERT and SELECT

  ON <TABLE-NAME> Specifies the table,view or synonyms

  TO <USER-NAME>   Specifies to whom the privileges are granted

  WITH GRANT OPTION  Specifies that the grantee may pass on the privileges

                                     that has been granted to another user.
  

           I think that this is helpful

Nabajit

• Mar 5th, 2007

 

Hi Guys..

U need to create ROLE for that user whose all access u want to grant to other.. Then just grant the whole ROLE to that user...

Thanks...

globalanil18

 Profile Answers by globalanil18 Questions by globalanil18

• Mar 12th, 2007

 

Thanks for reply meBut, We need to grant to over all permission to another user. Anyone as create any table in that user then another user will able to access that newly created table without giveing any sp. permission to that table. That means we have to provide over all permission of one user to another. Thank You

mukesh

• Mar 20th, 2007

 

SELECT 'GRANT ' ||privilege ||' ON '||table_schema||'.'||table_name ||' TO '||USER ||' ;' FROM ALL_TAB_PRIVS
WHERE grantee ='TILITS' -- user name that has already access 

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 2nd, 2010

 

Grant all privileges of user_name1 to user_name2 with grant option.

where user_name1 is the user of which we have to pass privileges,
and user_name2 is the user to which we are assign the privileges,
and grant  option is nothing but it allows the user_name2 to pass all privileges to another.