Home » Server Options » Replication » How Do I replicate GRANT to the others
How Do I replicate GRANT to the others [message #366562] Wed, 20 December 2000 05:46 Go to next message
Tatsuhiko Maekawa
Messages: 3
Registered: November 2000
Junior Member
On multi-master site, I created a table using
the replication. Then I wanted to grant some users
to see the table by granting, but it didn't work.

Does anyone know which API to use in order to
grant an table object to the others?

Report message to a moderator

Re: How Do I replicate GRANT to the others ... Later on [message #366563 is a reply to message #366562] Thu, 21 December 2000 18:33 Go to previous message
Tatsuhiko Maekawa
Messages: 3
Registered: November 2000
Junior Member
From the REPCATLOG, I found that 1031 error - isufficient privilege was the reason behind it. It all seems that DBMS_REPCAT.EXECUTE_DDL does allow to give permission to users thru grant option.

I shall check little more to see the result of it ...

Report message to a moderator

Previous Topic: Replication across platforms and across different Oracle versions
Next Topic: Re: Database links
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 06:39:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.