Home » SQL & PL/SQL » SQL & PL/SQL » how to commit grant on tables
how to commit grant on tables [message #283047] Mon, 26 November 2007 00:32 Go to next message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
CREATE PUBLIC SYNONYM excel_mof_ad_changed for gescom.excel_mof_ad_changed;

GRANT SELECT,UPDATE,INSERT ON excel_mof_ad_changed TO PUBLIC;

CREATE PUBLIC SYNONYM r_mof_t_brnch for gescom.rbi_mof_t_brnch;

GRANT SELECT,UPDATE,INSERT ON r_mof_t_brnch TO PUBLIC;

after this iam using commit command at splplus

but whenever i do a transaction from vb6.o each time i have to commit grant permissions each time at sqlplus...

is there any way to grant these operations permanently to the tables

[Updated on: Mon, 26 November 2007 00:36]

Report message to a moderator

Re: how to commit grant on tables [message #283062 is a reply to message #283047] Mon, 26 November 2007 01:00 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't understand a word of your post but all DDL (and so all the statements you gave) are implicitly commited.

Regards
Michel
Re: how to commit grant on tables [message #283080 is a reply to message #283047] Mon, 26 November 2007 01:26 Go to previous messageGo to next message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
if they are implicitly committed then why it is not accepting from vb6.0 select,update operations everytime.


for these two tables after one select,update operations are then again i have to grant and commit at sqlplus.

everytime i dont want to do this.help me

[Updated on: Mon, 26 November 2007 01:26]

Report message to a moderator

Re: how to commit grant on tables [message #283094 is a reply to message #283047] Mon, 26 November 2007 01:46 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

If you give grant to a table or create synonym for a table, thats it. It will be there unless you drop it or drop schema.

If you do any table updation/deletion/insertion then you need to commit the session.

That means for all DDL you no need commit. For DML you have to do commit.

Somewhere you confused.

Regards,
Kiran.
Re: how to commit grant on tables [message #283127 is a reply to message #283047] Mon, 26 November 2007 03:10 Go to previous messageGo to next message
mrkcse
Messages: 62
Registered: November 2007
Location: Mumbai,India
Member
iam creating synonymn only once, but grants for the tables i have to commit everytime i do a transaction from vb6.0
Re: how to commit grant on tables [message #283134 is a reply to message #283127] Mon, 26 November 2007 03:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

grants for the tables i have to commit everytime i do a transaction from vb6.0

This is wrong.
The behaviour is Oracle one and does not depend on client.
Grants are auto-committed.
Full stop.

If you see something different then either you didn't see correctly, you misinterpreted it or you wrongly did it.

Regards
Michel

[Updated on: Mon, 26 November 2007 03:19]

Report message to a moderator

Re: how to commit grant on tables [message #283138 is a reply to message #283047] Mon, 26 November 2007 03:24 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

You better give grant first and then create synonym for that table.

Regards,
Kiran.
Re: how to commit grant on tables [message #283144 is a reply to message #283138] Mon, 26 November 2007 03:36 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

You better give grant first and then create synonym for that table


Regards
Michel
Previous Topic: Dynamic Column Selection
Next Topic: Creating multiple level nested tables (merged 2 threads)
Goto Forum:
  


Current Time: Sat Dec 03 08:25:53 CST 2016

Total time taken to generate the page: 0.09177 seconds