Comments (7)
Hi @kkrasnov1 , thanks for reaching. Can you share a sample procedure object, with ACL and owner ? Use \df+
for example.
from ldap2pg.
DDL
CREATE SCHEMA ldap2pg_test AUTHORIZATION xxx;
create or replace procedure ldap2pg_test.proc1()
language plpgsql
as $$
begin
commit;
end;$$;;
psql
xxx=# \df+ ldap2pg_test.proc1
List of functions
-[ RECORD 1 ]-------+-------------
Schema | ldap2pg_test
Name | proc1
Result data type |
Argument data types |
Type | proc
Volatility | volatile
Parallel | unsafe
Owner | postgres
Security | invoker
Access privileges |
Language | plpgsql
Source code | +
| begin +
| +
| commit; +
| end;
Description |
ldap2pg output
GE Revoke privilege. grant="EXECUTE ON ALL FUNCTIONS IN SCHEMA xxx.ldap2pg_test TO public" database=xxx
GE Grant privilege. grant="EXECUTE ON ALL FUNCTIONS IN SCHEMA xxx.ldap2pg_test TO db_pg_test_xxx_datawriter" database=xxx
GE Grant privilege. grant="EXECUTE ON ALL FUNCTIONS IN SCHEMA xxx.ldap2pg_test TO db_pg_test_xxx_owner" database=xxx
GE Grant privilege. grant="EXECUTE ON ALL FUNCTIONS IN SCHEMA xxx.ldap2pg_test TO db_pg_test_xxx_owner" database=xxx
from ldap2pg.
Hi @bersace,
Is it possible to grant privileges to stored procedures?
from ldap2pg.
Hi @bersace, Is it possible to grant privileges to stored procedures?
You can manage EXECUTE on all functions with __execute_on_functions__
privilege.
See https://ldap2pg.readthedocs.io/en/latest/builtins/#execute-on-functions
from ldap2pg.
Hi @bersace, Is it possible to grant privileges to stored procedures?
You can manage only privileges per schema. No finer granularity.
from ldap2pg.
Hi @bersace, Is it possible to grant privileges to stored procedures?
You can manage EXECUTE on all functions with
__execute_on_functions__
privilege. See https://ldap2pg.readthedocs.io/en/latest/builtins/#execute-on-functions
Thank you. It works correctly.
from ldap2pg.
@bersace, every time I start, I get a message
CHANGE Revoke privilege. grant="EXECUTE ON ALL FUNCTIONS IN SCHEMA userdb.ldap2pg_test TO myuser" database=userdb
Am I doing something wrong or is it a bug in ldap2pg?
from ldap2pg.
Related Issues (20)
- ERROR: ldap2pg.script: TypeError: unhashable type: 'dict' HOT 2
- Configure role per database HOT 2
- ldap2pg does not synchronize when using {cn} in name or parent HOT 2
- Is predefined role pg_signal_backend required when.using unpriv user? HOT 3
- Complex AD configuration V6.0 HOT 1
- Configure Python Version of ldap2pg v5.9 HOT 8
- Match different Active Directories HOT 5
- ldap2pg cron.d HOT 3
- endless loop when trying to create roles with parent HOT 3
- ldap2pg 6 in official postgres-common repository HOT 2
- Drop schema cascade? HOT 1
- Issue with Applying Privileges for All Schemas HOT 8
- Connect to different Postgres Servers
- Use GSSAPI for directory authentication HOT 8
- WARN Unexpected DN HOT 11
- fallback_owner HOT 5
- Typo in documentation
- Runtime error : invalid memory address or nil pointer dereference HOT 2
- Requesting a new build of 5.xversion
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from ldap2pg.