Home » SQL & PL/SQL » SQL & PL/SQL » Insufficient privileges !?
Insufficient privileges !? [message #35813] Wed, 17 October 2001 02:08 Go to next message
André V. B.
Messages: 3
Registered: October 2001
Junior Member
I am with a problem in procedure in the hour of the execution in determined command " CREATE ROLE ROLE_NOVOS_USUARIOS NOT IDENTIFIED "
I occur the following error: "Insufficient privileges", but if I to execute direct the command it creates Role normally !!?

----------------------------------------------------------------------
Re: Insufficient privileges !? [message #35830 is a reply to message #35813] Wed, 17 October 2001 13:06 Go to previous message
palanikarupaiyan@hotmail.
Messages: 18
Registered: June 2001
Junior Member
I may correct that you can not use DDL ( DATA DEFINATION LANGUAGE) command inside of PL/SQL. This is why you are able to run at SQL*PLUS ...but not in PL/SQL

----------------------------------------------------------------------
Previous Topic: pl/sql question
Next Topic: posting to a table of records via HTML
Goto Forum:
  


Current Time: Sun Jun 13 11:33:57 CDT 2021