OraFAQ Forum: SQL & PL/SQL » GRANTS to user to insert data in table with procedure

Home » SQL & PL/SQL » SQL & PL/SQL » GRANTS to user to insert data in table with procedure

Wed, 02 April 2014 01:45

Alexey.Samoilov
Messages: 11
Registered: April 2014

Junior Member

GRANTS to user to insert data in table with procedure
INSERT and EXECUTE. But how it will be written?
My try:

GRANT FORCE INSERT INTO User1.tab1 FOR USING IN EXECUTE ON stg.log_to_tab TO DWH;

Have some mistake (Oracle Version 11.2.0.3.0)
Error report:
SQL Error: ORA-00990: 00990. 00000 - "missing or invalid privilege"

Wed, 02 April 2014 01:53

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

This is not a valid Oracle SQL statement.
Have a look at Database SQL Reference.

Quote:

GRANTS to user to insert data in table with procedure

This does not exist in Oracle.
(For instance) You grant EXECUTE privilege on a procedure which owner has the INSERT privilege in the table.

Wed, 02 April 2014 02:27

Alexey.Samoilov
Messages: 11
Registered: April 2014

Junior Member

Thanks!

Previous Topic:	Change by query widt
Next Topic:	ROW_NUMBER() OVER( ORDER BY 2, 1 )

Goto Forum:

]

Current Time: Fri Apr 26 23:13:18 CDT 2024