of course ! shame on me It must have been this sales guy, talking insitently on me is driving me mad............................. .....and we are on 10g, not on 10i...... :-( think I need a break............... nice weekend to all of you > Frank < -----Original Message----- From: Mercadante, Thomas F (LABOR) [mailto:Thomas.Mercadante@xxxxxxxxxxxxxxxxx] Sent: Friday, July 01, 2005 2:19 PM To: Foelz.Frank@xxxxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: privilege on grant Frank, If a user owns an object, he automatically has the priv to grant access to the object to someone else. So the short answer is None. Tom _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Foelz.Frank Sent: Friday, July 01, 2005 8:00 AM To: oracle-l@xxxxxxxxxxxxx Subject: privilege on grant short question, which privilege must a user have to "GRANT" a SELECT privilege on his objects to another user Is there a difference between Oracle 9.x and 10i ? > Frank <