ORA-01933: cannot create a stored object using privileges
from a role



ORA-01933: cannot create a stored object using privileges from a role..

Answer / guest

Cause: An attempt was made to create a stored object using
privileges from a role. Stored objects cannot use privileges
from roles.

Action: Grant the privileges required to the user directly.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02876: smpini: Unable to attach to shared memory for PGA

1 Answers  


TNS-00035: INTCTL: error while constructing full file name

1 Answers  


RMAN-08035: partial resync skipped, target database not mounted

1 Answers  


ORA-23491: no valid extension request at "string"

1 Answers  


ORA-06434: ssaio: read error, unable to read requested block from database file.

1 Answers  






ORA-01620: no public threads are available for mounting

1 Answers  


PCC-01016: "N" character literals not supported in embedded PL/SQL

1 Answers  


O2F-00323: Internal error in OTT facility O2F

1 Answers  


ORA-26102: relative file # in file header is string rather than string for file string

1 Answers  


ORA-28509: unable to establish a connection to non-Oracle system

1 Answers  


ORA-00255: error archiving log string of thread string, sequence # string

1 Answers  


ORA-29357: object string already exists

1 Answers  


Categories