Oracle FAQ

Your Portal to the Oracle Knowledge Grid

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

Home -> Community -> Usenet -> c.d.o.misc -> Re: stored proc to create sequence, insufficent priv

Re: stored proc to create sequence, insufficent priv

From: Kay Kanekowski <kay.kanekowski_at_web.de>
Date: Thu, 24 Apr 2003 22:34:31 +0200
Message-ID: <b89hqg$7n912$1@ID-183343.news.dfncis.de>

Hi Ken,

you need the right 'create <object_type>' explizit, not via role if you want to create an object with dynamic sql in a procedure

hth
Kay Received on Thu Apr 24 2003 - 15:34:31 CDT

This message: [ Message body ]
Next message: Sybrand Bakker: "Re: How to name the password?"
Previous message: Daniel Morgan: "Re: I am getting my first Certification: 8i or 9i?"
In reply to: Ken Chesak: "Re: stored proc to create sequence, insufficent priv"
Next in thread: Daniel Morgan: "Re: stored proc to create sequence, insufficent priv"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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