• State Suggested Answer
  • Locked Locked
  • Replies 12 replies
  • Answers 1 answer
  • Subscribers 13 subscribers
  • Views 11959 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
    Without having the migration log, I'm thinking the line: exit | sqlplus system/$2 @$1 >/tmp/$1.log maybe the issue. I usually use: echo "exit" | sqlplus system/$2 @$1 >/tmp/$1.log . You don't need to redirect to: > /tmp/$1.log, I would remove it.

    I always make sure my scripts work outside of Stat first before trying with Stat.
Reply
  • 0 over 6 years ago
    Without having the migration log, I'm thinking the line: exit | sqlplus system/$2 @$1 >/tmp/$1.log maybe the issue. I usually use: echo "exit" | sqlplus system/$2 @$1 >/tmp/$1.log . You don't need to redirect to: > /tmp/$1.log, I would remove it.

    I always make sure my scripts work outside of Stat first before trying with Stat.
Children
No Data