In a 12.0.1 database that makes use of client-file reads via READ_CLIENT_FILE(), which system table/view does list whether a particular user/group has been granted the according READCLIENTFILE/WRITECLIENTFILE authority? SYSUSERAUTH and SYSUSERPERM and their variations seem to list the "basic" authorities like RESOURCE, DBA, REMOTEDBA and the like, but they do not tell about the ones introduced with v11 (i.e. PROFILE, READCLIENTFILE, READFILE, and WRITECLIENTFILE). |
OK, got it, it's listed in SYSUSERAUTHORITY - in contrast to SYSUSERAUTH, this one does not have a separate column for each authority but a row for each granted authority... A helpful query: select user_name, auth from sys.sysuser key join sys.sysuserauthority where user_name = 'MyUser' order by 1, 2 |