• State Suggested Answer
  • Locked Locked
  • Replies 12 replies
  • Answers 1 answer
  • Subscribers 13 subscribers
  • Views 11973 views
  • Users 0 members are here
Options
Related
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

smoturu
over 6 years ago

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
  • 0 over 6 years ago
    The location you are putting it is not the best location. That location would be used for every one of your Stat EBS Agents. It should be a common location that is available to all of your Stat EBS Agents. Our Stat installation has over 40 Stat EBS agents across 24 host servers.

    Not sure of your setup, but the location can be in your UNIX PATH variable in which case you only need the script name of "xxea_grant_stmt.sh". If you use /usr/local/bin in your UNIX PATH variable and are allowed to put scripts there, that is an option.

    For our setup, I modified the UNIX PATH variable on each server to include the location of the script and located the script on each server in that directory location. For our installation it is common across all 24 hosts in directory: /stat/scripts.

    Your other option is to use the full path name, but that full path name will be used by each Stat EBS agent.

    Hope this help.

    Tom
Reply
  • 0 over 6 years ago
    The location you are putting it is not the best location. That location would be used for every one of your Stat EBS Agents. It should be a common location that is available to all of your Stat EBS Agents. Our Stat installation has over 40 Stat EBS agents across 24 host servers.

    Not sure of your setup, but the location can be in your UNIX PATH variable in which case you only need the script name of "xxea_grant_stmt.sh". If you use /usr/local/bin in your UNIX PATH variable and are allowed to put scripts there, that is an option.

    For our setup, I modified the UNIX PATH variable on each server to include the location of the script and located the script on each server in that directory location. For our installation it is common across all 24 hosts in directory: /stat/scripts.

    Your other option is to use the full path name, but that full path name will be used by each Stat EBS agent.

    Hope this help.

    Tom
Children
No Data