E-Business Suite

Blog consists of oracle ebusiness suite code

Tuesday, 5 January 2016

plsql- creating a custom table and grant access to apps schema and production read only user


Whenever a custom table is created as XX01.XX_EMP_DATA; i.e XX01 schema

Then this table should be grant to apps schema

GRANT ALL ON XX_EMP_DATA TO APPS;

GRANT SELECT ON XX_EMP_DATA  TO APPS_RO;

above APPS_RO is the production read only and APPS is the schema

Instead of apps an USER_NAME can also be given access to specific user
Posted by Unknown at 07:59 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
View mobile version
Subscribe to: Comments (Atom)

About Me

Unknown
View my complete profile

Blog Archive

  • ►  2017 (2)
    • ►  August (1)
    • ►  July (1)
  • ▼  2016 (9)
    • ►  October (1)
    • ►  September (1)
    • ►  July (3)
    • ►  April (1)
    • ►  February (2)
    • ▼  January (1)
      • plsql- creating a custom table and grant access to...
  • ►  2015 (16)
    • ►  December (2)
    • ►  November (1)
    • ►  September (1)
    • ►  August (1)
    • ►  February (7)
    • ►  January (4)
  • ►  2014 (21)
    • ►  December (2)
    • ►  November (6)
    • ►  October (2)
    • ►  September (1)
    • ►  August (8)
    • ►  March (2)
Ethereal theme. Powered by Blogger.