This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

How to migrate DB grants using STAT 5.7.4

We are using STAT 5.7.4 for our Oracle R12 migrations.  Currently we are migrating DB grants manually and want to leverage STAT for this purpose.  For all other objects like tables, procedures, packages etc. we are using STAT.  But not sure how to migrate grants.

 

Thanks

Santosh

Parents
  • Hi Santosh,

    When you define the Custom File Object,  Check "For DB" and you will need to create a shell script that get used in "Define Generate Command" tab.  The script needs to be in a PATH that is available on all of your EBS Agent hosts.  The TARGET_OBJECT_NAME parameter is the SQL script that contains the grant commands.

    Grant_Statement.sh  -f %%TARGET_OBJECT_NAME%% -p %%TARGET_SYSTEM_PASSWORD%%

Reply
  • Hi Santosh,

    When you define the Custom File Object,  Check "For DB" and you will need to create a shell script that get used in "Define Generate Command" tab.  The script needs to be in a PATH that is available on all of your EBS Agent hosts.  The TARGET_OBJECT_NAME parameter is the SQL script that contains the grant commands.

    Grant_Statement.sh  -f %%TARGET_OBJECT_NAME%% -p %%TARGET_SYSTEM_PASSWORD%%

Children
No Data