728 questions
1
vote
1
answer
67
views
Unallowed GRANT does not raise an exception and doesn't grant the privilege either, if user already has other privileges on the object
I have a regression test for a PostgreSQL database that checks to make sure a particular user cannot self-assign additional privileges to a particular schema. I do this by logging in as the user "...
- 1,015
0
votes
0
answers
43
views
utPLSQL in Oracle SQL Developer: ORA-01031: insufficient privileges
I'm using utPLSQL to perform unit testing in Oracle. Here are all the privileges I granted to the user in the utPLSQL schema:
GRANT EXECUTE ON DBMS_LOCK TO utester;
GRANT CREATE SESSION TO utester;
...
- 1
0
votes
1
answer
72
views
Access system object via a view whose owner is granted with grant option
I have created the following view in my database, my schema
CREATE VIEW [OMEGACA].[V_SYS_MANAGE_ACC]
AS
SELECT
name, object_id, parent_class, parent_class_desc, parent_id,
...
- 375
0
votes
1
answer
52
views
No privileges when executing Oracle stored procedure
I have a problem with an Oracle stored procedure that dynamically creates some materialized views.
The procedure first drops the materialized views if there are any with the same name of the ones that ...
- 17
1
vote
1
answer
378
views
ORA-27486: Insufficient Privileges
I'm getting "ORA-27486: Insufficient privileges" error.
What grants am I missing here?
I'm executing an insert script using DBMS_PARALLEL_EXECUTE and I'm getting getting this error in ...
- 13
1
vote
0
answers
297
views
Why one superuser cannot use GRANT in Postgres 16
Postgres 16 has user ingmar which is marked as superuser and has create role rights:
CREATE ROLE ingmar WITH
LOGIN
SUPERUSER
INHERIT
CREATEDB
CREATEROLE
NOREPLICATION
BYPASSRLS
...
- 28.2k
0
votes
1
answer
335
views
Cannot grant user privilege to create REFERENCES in MySQL 8
I tried to create the quartz table with a user that has privilege as below.
Privileges: [Select, Insert, Update, Delete, Create, Drop, File, Index, Alter, Show databases, Create temporary tables, Lock ...
0
votes
1
answer
77
views
Grant user to create table oracle
In my oracle 23ai instance, as ADMIN user I created this user:
CREATE USER IF NOT EXISTS USER000 IDENTIFIED BY MyHardP4ssword';
Then I granted him some privileges:
GRANT RESOURCE, CONNECT, CREATE ...
- 843
0
votes
0
answers
55
views
Oracle Revoke Invalid Grants
I'm currently in the process of migrating a database, and dropping several schemas in the move.
The schemas I'm excluding have grants on some of the schemas that are included. Like grant update on ...
- 266
2
votes
1
answer
151
views
How to retrieve user access rights with FireDAC
I am using FireDAC to access a MySQL database from within Delphi.
When logging in into the database I give in the database user name, which is defined within MySQL and has certain access right.
How ...
0
votes
1
answer
274
views
Only allow user to Execute a specific procedure
I'm looking for a solution where a user's only permission it to execute a procedure. In my example below, that procedure is lowlevel.ZipFile (Main Procedure). The problem is that the procedure itself ...
- 304
0
votes
1
answer
216
views
How to grant execution permission on procedure to ALL USERS
I need to grant all users with execution permissions to execute myprocedure
I'm using this:
grant execute on procedure myprocedure to '*'@'%%';
And I got this:
SQL Error [1410] [42000]: You are not ...
- 843
0
votes
1
answer
2k
views
postgres user has no access to public schema
I am getting the following error on postgresql 12:
ERROR: permission denied for schema public
even though I am logged in as postgres (who is superuser), and I have granted all on the schema, and on ...
- 33.8k
2
votes
1
answer
1k
views
GRANT USER to another user does not grant permissions
I have user 'administrator' with CREATEROLE privileges. I create new user like this:
CREATE USER test_user;
And then i grant privileges to the new user:
GRANT administrator TO test_user;
When i'm ...
- 53
2
votes
1
answer
3k
views
Is there any way to grant RDSADMIN USER privileges to a user?
GRANT APPLICATION_PASSWORD_ADMIN,BACKUP_ADMIN,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,
INNODB_REDO_LOG_ARCHIVE,PASSWORDLESS_USER_ADMIN,SHOW_ROUTINE
I want to grant these ...
- 23
1
vote
0
answers
330
views
How to assign query permissions to a role for all tables in a database when hive.security.authorization.enabled is set to true
I want to restrict the access rights of different users through the standard SQL permission control that comes with Hive, but I don't know that if you can batch authorize tables under a certain ...
- 11
0
votes
1
answer
190
views
DBA grant option and permission issue
In MySQL database, If a DBA grant select to a user1 as well as with grant option, then this user1 grant select access to user 2, can the DBA revoke user2 but not affect user 1 permission?
I tried ...
- 39
0
votes
1
answer
255
views
Clear/remove all GRANT and DENY of a user in SQL
I see a lot of GRANT and DENY records in table sys.database_permissions for a specific user.
How can I delete/clear all these entries?
I need to clear to run a script that will do the appropriate ...
- 912
1
vote
1
answer
491
views
oracle sql 'Alter USER test_user2 GRANT CONNECT THROUGH test_user1 ROLE myTestRole1;' throwing 'ORA-00933: SQL command not properly ended' error
I'm executing the following sql
Alter USER test_user2 GRANT CONNECT THROUGH test_user1 ROLE myTestRole1;
in Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 database and running in to the ...
- 13
0
votes
1
answer
150
views
Creating users with different privileges and list these users with their privileges in PostgreSQL
I want to create users with different priviledges for example read and write and admin for just a database.
I create users with grants but when I use \du it doesn't show me anything that I can use to ...
- 405
0
votes
0
answers
35
views
GRANT ALL doesnt work for new tables in postgres [duplicate]
I have script to create user and grant all privileges for table in postgres
create user dev_api with encrypted password 'xxx';
grant all privileges on database dev to dev_api;
ALTER USER dev_api ...
- 63
1
vote
1
answer
682
views
How to know if oracle GRANT command actually changed anything
Having run a grant command in an Oracle SQL script, is there any way to tell if it actually changed anything. Like an equivalent of SQL%ROWCOUNT or similar?
I am writing an ansible module which will ...
- 6,812
0
votes
1
answer
46
views
PLSQL Grant on Tables used on a package
I have two procedures one defines and uses a CURSOR with table from another schema and it gives me an error of insufficient privileges; the other one, creates a table with a dynamic SQL, referencing ...
0
votes
0
answers
428
views
GRANT CREATE only on specific schema to specific role SQL Server
I'm looking to GRANT all sorts of CREATE statements on specific schemas in my DB for specific members of a role;
Here's my current setup, I have:
Schema A
Schema B
Role A
Role B
SQL Login A
SQL ...
- 65
1
vote
0
answers
123
views
How to access granted media_projection thought root?
how can I use the root command to grant permission to "media projection" or to another: "screen capture/screenshot"? maybe it's some kind of "activity" you need to run?
I ...
- 11