Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Creators and owners

Creators and owners

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 15 Apr 1999 11:13:22 GMT
Message-ID: <01be8739$51ae0fc0$2c289a0a@apollo>


Thanks for the fast and good answer.

> In Oracle8.0 and below procedures ALWAYS run with the base privileges of
the
> CREATOR of the procedure -- never, never as the OWNER of the procedure.

What is the difference between CREATOR and OWNER?

My understandig was that if myUser executes 'CREATE TABLE myTable ...' then myUser is the owner and creator of myTable. How is this different with procedures?

Thanks
Peter Received on Thu Apr 15 1999 - 06:13:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US