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).

asked 06 Jul '16, 09:47

Volker%20Barth's gravatar image

Volker Barth
30.0k294449654
accept rate: 32%

edited 06 Jul '16, 09:54


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
permanent link

answered 06 Jul '16, 10:58

Volker%20Barth's gravatar image

Volker Barth
30.0k294449654
accept rate: 32%

edited 06 Jul '16, 11:02

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×409
×24
×17

question asked: 06 Jul '16, 09:47

question was seen: 178 times

last updated: 06 Jul '16, 11:02