afpub.sql

Posted on June 26, 2008. Filed under: DBA/Admin Tips, R12, TroubleShooting | Tags: |

Never ever run this script when the instance is up and running. Wondering what will happen if you run … pretty simple … nobody can login to the instance including SYSADMIN user even with the correct password.

Oracle Ebusiness Suite security best practices document suggests to run this script to grant and revoke permissions to/from applsys user.

The best way to do this is to run Recreate Grants and Synonyms using adadmin.

cheers,
OraclePitStop

Advertisements

Make a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Liked it here?
Why not try sites on the blogroll...

%d bloggers like this: