|
Re: checking users execute previlege on ALIAS LIBRARY [message #570945 is a reply to message #570939] |
Mon, 19 November 2012 03:41 |
|
Littlefoot
Messages: 21823 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
DICTIONARY is a cool thing; bookmark it and use it when necessary.
For example:SQL> select * from dictionary
2 where upper(comments) like '%PRIV%' or upper(comments) like '%GRANT%'
3 order by table_name desc;
TABLE_NAME COMMENTS
------------------------------ --------------------------------------------------
USER_TAB_PRIVS_RECD Grants on objects for which the user is the grante
e
USER_TAB_PRIVS_MADE All grants on objects owned by the user
USER_TAB_PRIVS Grants on objects for which the user is the owner,
grantor or grantee
<snip>
Review the result and locate the one(s) that seem to do what you're after. In your case, that might be USER_TAB_PRIVS, i.e.
select * from user_tab_privs where table_name = 'ALIAS_LIBRARY'; If not, try something else (I don't know what "ALIAS LIBRARY" is).
[Updated on: Mon, 19 November 2012 03:43] Report message to a moderator
|
|
|
|
|
|
|
|
Re: checking users execute previlege on ALIAS LIBRARY [message #570956 is a reply to message #570951] |
Mon, 19 November 2012 05:17 |
|
Michel Cadot
Messages: 68728 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
On Linux, exit code falls on the range 0-255, a value of 256 just means either it was 0 and there was an extra byte which contains 1, either the program you called in system returns an invalid exit code. (Note that some Linux flavours and versions return 255 when you give an invalid value, some not.)
Generally speaking, in my opinion, when using such interfaces between subsystems (OS/Oracle), you should use mod(exit_code,256) to test the return code.
Regards
Michel
|
|
|