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.
Questions tagged [acl]
8 questions
4
votes
2 answers
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 to only allow the execution of list_t(), while…
Katrin
- 369
- 2
- 8
4
votes
2 answers
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',
description => 'WWW ACL',
principal =>…
Mark Harrison
- 829
- 5
- 20
- 33
0
votes
1 answer
Find all sequences and other schema objects owned not by certain user
How can I find all sequences (and more widely - all objects in given schema), which are owned not by certain user, on PostgreSQL (10-15)?
I found such query:
SELECT relname, relacl
FROM pg_class pgc
WHERE relkind = 'S'
AND relacl is not null
AND…
lospejos
- 109
- 5
0
votes
3 answers
Create Sequence Permission for Postgres
When my postgres function is tries to create a new sequence, it returns a permission denied error. It looks like the only way to make it work is to give Create permission on schema using the below statement.
GRANT CREATE ON SCHEMA public to…
Harshit Tekriwal
- 1
- 1
0
votes
2 answers
Is it possible to limit connecting users to a schema from specific terminal or program?
I read about Oracle ACL, but on first sight, it doesn't look like it limits the access to a schema on terminal, program level. Is it even possible? I did experience such limitation once. I was connecting by sqlplus from unix box, the same box the…
Jakub P
- 167
- 1
- 2
- 10
0
votes
1 answer
How to implement UNIX like ACL for table rows
EDIT: I can't create or use native MySQL users. I have to use users stored in table with their password hash.
I am new sql stuff so please forgive me for asking dumb question. I am creating my first real life application for college project.
At its…
LightSith
- 101
- 3
0
votes
0 answers
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 redundant commands like this:
REVOKE ALL ON schema…
Daniel Soutar
- 101
- 1
0
votes
1 answer
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 https to an external server. The acl seems to be…
OldProgrammer
- 147
- 1
- 9