database full export [message #70823] |
Sun, 28 July 2002 22:34 |
jag
Messages: 15 Registered: July 2002
|
Junior Member |
|
|
hi,
i would like to know how a particular user can be given the privileges so that a full/incremental/cummulative backup can be taken from that user. it must also update the sys files INCVID,INCFIL, & INCEXP.
thanks.
|
|
|
Re: database full export [message #70831 is a reply to message #70823] |
Mon, 29 July 2002 02:42 |
sunil bhola
Messages: 58 Registered: July 2002
|
Member |
|
|
for this the user must have EXP_FULL_DATABASE & IMP_FULL_DATABASE privilege.
but if the user have CREATE SESSION privilege then he/she can export ONLY his/her scheme data.
how to assign privilege to the user
grant exp_full_database, imp_full_Database to sunil;
|
|
|