Questions tagged [acl]

ACL refers to Access Control List. An Access Control List contains entries describing who or what has rights to the object the ACL is attached to. This tag should be used for questions relating to database ACLs.

Filter by
Sorted by
Tagged with
0
votes
0answers
23 views

Can I get pg_dump to simplify the ACL commands?

When using pg_dump with a database with non-default schema foo like so: pg_dump --schema-only --schema='foo' -U myuser -d mydb -h myhost -W > mydb.sql The SQL dump file is full of these seemingly ...
0
votes
1answer
236 views

SET_AUTHENTICATION_FROM_WALLET call returns ACL error

Running Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production. Have a wallet setup containing a basic authentication credential. PL/sql package is executing a request over ...
2
votes
1answer
54 views

Only allow access to a table via a function, not directly via queries

I have a table t and some functions which access t. For example: create function list_t() returns setof t as $$ select * from t; $$ language sql stable; Is it possible to define role permissions ...
0
votes
0answers
30 views

Oracle - 'Correctly' configured ACL fails with network access denied by ACL

I have the exact same ACL privileges (used same sql script) on two separate databases. It works on one, but is denied on the other. Both databases are meant to connect to the same resource. Tried ...
1
vote
2answers
28k views

Oracle: Viewing settings for DBMS_NETWORK_ACL_ADMIN ACL?

How do I view the contents of a network ACL? For example, if I create this ACL, how can I view what settings have been applied to it? DBMS_NETWORK_ACL_ADMIN.CREATE_ACL( acl => 'www.xml', ...