Oracle - What is a surrogate repadmin user and how is one created? posted by
Babu Kunwar
What is a surrogate repadmin user and how is one created?
Surrogate repadmin user can be created by executing the query: We need to make
the following API
EXECUTE DBMS_REPCAT_AUTH.GRANT_SURROGATE_REPCAT(userid =>
'surrogate_user_name');
The main purpose of the surrogate repadmin user is: if we create one surrogate
repadmin user at remote site then we don’t have to maintain a SYS to SYS
database connection. This user will only perform all the operation on the
behalf of replication. But the user must have administrator privileges. Simply
we can say that surrogate repadmin user is a clone for SYS.
More links
What are PL/SQL Subprograms?
Advantages of PL/SQL Subprograms.
PL/SQL has two types of subprograms called procedures and functions. Explain
them.
How does subprogram pass information? What are actual and formal subprogram
parameters? Explain with an example
Define three parameter modes, IN (the default), OUT, and IN OUT that can be
used with any subprogram............ .
|
