SQL> Create directory PAP_HOME_DIR as '/userdata/applications/cusap/data/gs_data';
SQL> grant read, write on directory PAP_HOME_DIR to APPS;
To query the privileges given to directory execute the following:
SQL> SET lines 80
SQL> COL grantee FORMAT a20
SQL> COL privilege FORMAT a10
SQL> SELECT directory_name, grantee, privilege FROM user_tab_privs t, all_directories d
WHERE t.table_name(+)=d.directory_name ORDER BY 1,2,3;
SQL> grant read, write on directory PAP_HOME_DIR to APPS;
To query the privileges given to directory execute the following:
SQL> SET lines 80
SQL> COL grantee FORMAT a20
SQL> COL privilege FORMAT a10
SQL> SELECT directory_name, grantee, privilege FROM user_tab_privs t, all_directories d
WHERE t.table_name(+)=d.directory_name ORDER BY 1,2,3;
1 comment:
thanks for this information now i can create my own directory in DBA.
Laxmi Nagar to Hauz Khas Metro Station
Post a Comment