728 questions
1
vote
1
answer
69
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 "...
- 29.9k
1
vote
2
answers
16k
views
Oracle SELECT granted but still can't access table across users
Can any one see what's wrong with this:
User ABC:
create table def.something (
id number,
ref number references def.anotherTable(id)
);
create role ROUser;
grant select on def.something to ...
CommunityBot
- 1
2
votes
2
answers
18k
views
unable to grant LOCK TABLES permission to user
I'm running MySQL 5.1.73-0ubuntu0.10.04.1-log and I'm trying to make it so a user can LOCK TABLES. I GRANTed LOCK TABLEs with the following:
GRANT SELECT, LOCK TABLES ON *.* TO 'dbuser';
That responds ...
CommunityBot
- 1
4
votes
2
answers
2k
views
Grant remote access to mysql for an ipv6 subnet
This is a similar question to How to grant remote access to MySQL for a whole subnet?, but with an IPv6 subnet. According to https://dev.mysql.com/doc/refman/5.5/en/account-names.html, the host_ip/...
- 578
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;
...
- 173k
1
vote
1
answer
97
views
Grant with Grant option not working in SQL Server
I have two server logins, OMEGACA and TEST, and an ALL SERVER for LOGON trigger:
CREATE TRIGGER [OMEGACA_ACC]
ON ALL SERVER WITH EXECUTE AS 'OMEGACA'
FOR LOGON
AS
-- ...............
OMEGACA has ...
- 78.5k
1
vote
2
answers
1k
views
Grant user to multiple db but only one table
I'm trying to grant access one user to many db that have been created on my system like this:
dbUser_1
dbUser_2
...
and so on.
I can use GRANT SELECT, INSERT, UPDATE ON `dbUser\_%`.* TO 'kenny'@'...
- 394
0
votes
1
answer
152
views
PostgreSQL privilege, setting or feature to limit number of rows a user can select
Using PostgreSQL, is it somehow possible to restrict the SELECT privilege of a certain user so that he can only select a certain limited number of rows from a certain table?
For example, user joe ...
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 ...
- 22.9k
3
votes
1
answer
183
views
Postgres Permissions violated by before-insert trigger function
I've got a table with row level permissions enabled. I've got an insert policy for my user, and I've granted permissions for them on specific columns. I added a new column to track the id of whoever ...
- 257k
0
votes
1
answer
555
views
How to get Future Grants over Schema in Snowflake?
I have a use case where I need to check for FUTURE grants on an input database and schema. If FUTURE grants are found and not match with Input Role then I want to revoke them and then assign the ...
- 815
4
votes
2
answers
27k
views
MySQL Error: #1142 - TRIGGER command denied
I need that my MySQL database makes a sum of some values in a specific column. To do that, I used trigger statement, but I get an error from MySQL:
MySQL Error: #1142 - TRIGGER command denied to user ...
- 760k
15
votes
3
answers
99k
views
Correct way to give users access to additional schemas in Oracle
I have two users Bob and Alice in Oracle, both created by running the following commands as sysdba from sqlplus:
create user $blah identified by $password;
grant resource, connect, create view ...
CommunityBot
- 1
45
votes
7
answers
153k
views
Execute command denied to user ''@'localhost' for routine error
I have some problem during open my old website. My dataTable show:
DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error.
After that, I tried to ...
- 42.5k
3
votes
3
answers
5k
views
how to grant update or select on some specified row in postgresql table?
I want to create some roles in my Postgresql DB and grant some access.
I have student role and i want to grant this user type : can edit only record a bout him/her in student table and can not edit ...
- 329k
2
votes
1
answer
2k
views
user cannot create table on schema public Postgres 16
I have to create a table in Postgres public schema for Airflow implementation. When I create a table with airflow user I get this error
permission denied for schema public
LINE 1: CREATE TABLE public....
- 129k
2
votes
1
answer
6k
views
How to grant SELECT on information_schema.views?
Is there a way to grant read-access on objects in information_schema, in this case the table views?
I want to run my web application with a very restricted user, but at some places he needs to query ...
- 668k
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
5
votes
4
answers
38k
views
#1142 - INSERT command denied to user ___ for table ___
Apparently this is usually to do with size, but I only have one table with six columns.
The only thing that has changed recently is that today I installed a forum but I've removed it again and the ...
- 2,388
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 ...
- 36.7k
0
votes
0
answers
182
views
supabase postgress roles error in flutter
in supabase
after creating role 'adminRole'
then granting the role to an email through
update auth.users set role = 'adminRole' where email='my email';
i checked the table and it did update.
then ...
- 1
356
votes
23
answers
1.1m
views
grant remote access of MySQL database from any IP address
I am aware of this command:
GRANT ALL PRIVILEGES
ON database.*
TO 'user'@'yourremotehost'
IDENTIFIED BY 'newpassword';
But then it only allows me to grant a particular IP address to access this ...
- 4,440
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 ...
- 97.7k
770
votes
10
answers
994k
views
Create new user in MySQL and give it full access to one database
I want to create a new user in MySQL and give it full access only to one database, say dbTest that I create with a command like create database dbTest;. What would be the MySQL commands to do that?
- 42.7k
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 ...
- 126k