[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::dec_data_distributor

Title:	The Replication Option for Rdb
Notice:	Product renamed to Replication Option for Rdb
Moderator:	BROKE::PROTEAU

Created:	Wed Mar 02 1994
Last Modified:	Wed Jun 04 1997
Last Successful Update:	Fri Jun 06 1997
Number of topics:	287
Total number of notes:	1231

240.0. "NO_PRIV error / REPLICATION transfer" by ORAREP::VAXRIO::ABREU () Wed Sep 11 1996 15:47

    Hi,
    
        I have a customer trying to start a REPLICATION transfer but he is 
    receiving an error message NO _PRIV ( part of the log is shown below).
       
        Which privileges does he need on the destination database and table
    to make it work ?
    
        Privileges are shown below ...after the log .
    
         Thanks .. Marcia
        
    
        VDD 6.0 and RDB 6.1-4  
     
    10:43:41  %DDAL-I-READTRDEF, reading the transfer definition from the
              transfer *
    10:43:43  %DDAL-I-ATTACHSDB, attaching to source database
     10:43:44  %DDAL-I-ATTACHTDB, attaching to target database BDO
    10:43:46  %DDAL-I-STADATTRM, starting data transfer/modification
    ----- 11-SEP-1996 10:43:48.64 ----- Error          
    -------------------------
    %DDAL-E-ERRACCDSTDB, error occurred accessing the destination database
    -DDAL-E-SUPP, %RDB-E-NO_PRIV, privilege denied by database facility
    
Protection on Alias BDO
    (IDENTIFIER=[BDO],ACCESS=SELECT+INSERT+UPDATE+DELETE+
                CREATE+ALTER+DROP)

  ---- SHOW PROT ON TABLE BDO.DADOS_DO_SETRAE

Protection on Table BDO.DADOS_DO_SETRAE
    (IDENTIFIER=[BDO],ACCESS=SELECT+INSERT+UPDATE+DELETE+CREATE+ALTER+DROP)

T.R	Title	User	Personal Name	Date	Lines
240.1	Look at the TO clause in CREATE TRANSFER	BROKE::PROTEAU	Jean-Claude Proteau	`Thu Sep 12 1996 10:11`	36
	Marcia, One cannot tell just from the information in the log file what privilege is missing on which database object. That's because we don't know what query was being performed at the time of the error. Let me offer some suggestions. 1. Check privileges on the RDB$VINTAGE and on the RDBVMS$TRANSFER_ OWNER tables in the target database. I assume the transfer is to an Rdb target database and that the transfer is TO EXISTING target database. If not, then different tables might be involved. 2. Do you know for certain under what account the target database is being accessed during the transfer? That is determined by the database access string specified by the TO clause in the CREATE TRANSFER statement. 3. To find out what query was last compiled prior to the error, you can enable Rdb debug output by $ DEFINE RDMS$DEBUG_FLAGS B. This outputs the BLR statements generated during database query compila- tion. 4. If the transfer is being executed from the correct account and there really is some privilege that is missing, try adding, one at a time, other Rdb privileges until you discover which one is needed. My guess is that the transfer definition was not created correctly. I think that the TO clause, which names the target database and the account to use at the remote site to get into the target database, is where the problem might be. Regards. Claude
240.2	It Worked .. but which privileges	ORAREP::VAXRIO::63230::abreu		`Thu Sep 12 1996 14:22`	12
	Claude, We changed the protection for the identifier to give ALL privileges in the database and in the table that was receiving the data. And it worked just fine. The problem is that the customer wants to know if this identifier really needs all these privileges. Thks, Marcia
240.3	Not from memory	BROKE::PROTEAU	Jean-Claude Proteau	`Thu Sep 12 1996 17:45`	12
	All privileges should not be necessary. I do not definitively know which privileges are the correct ones. Your customer could log a problem report and we will research this. If your customer needs an answer right away, it would be faster for him/her to experiment by removing privileges one at a time, redoing the transfer, and determining which ones have an effect. Claude
240.4	I'll talk to the customer	ORAREP::VAXRIO::63230::abreu		`Fri Sep 13 1996 08:57`	9
	Hi Claude, I'll talk to him but I guess he thougth this could be written somewhere. I'll tell him that you would have to research , I guess he won't insist on this. If I'm wrong , I open a formal call. Thanks ! M�rcia
240.5		BROKE::PROTEAU	Jean-Claude Proteau	`Fri Sep 13 1996 11:04`	2