92 questions
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 ...
- 33.9k
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?
- 7,717
128
votes
2
answers
273k
views
Grant all on a specific schema in the db to a group role in PostgreSQL
Using PostgreSQL 9.0, I have a group role called "staff" and would like to grant all (or certain) privileges to this role on tables in a particular schema. None of the following work
GRANT ALL ON ...
- 15.6k
369
votes
10
answers
857k
views
PostgreSQL: Give all permissions to a user on a PostgreSQL database
I would like to give a user all the permissions on a database without making it an admin.
The reason why I want to do that is that at the moment DEV and PROD are different DBs on the same cluster so I ...
- 36.5k
25
votes
3
answers
48k
views
How can I restrict a MySQL user to a particular tables
How can I restrict a user_account in MySQL database to a particular tables. Ex:
UserName: RestrictedUser
DatabaseName: db_Payroll
TableName:
tb_Employees
tb_Users
tb_Payroll_YYMMDD
...
- 658
90
votes
4
answers
78k
views
Minimum GRANTs needed by mysqldump for dumping a full schema? (TRIGGERs are missing!!)
I have a MySQL user called dump with the following perms:
GRANT USAGE ON *.* TO 'dump'@'%' IDENTIFIED BY ...
GRANT SELECT, LOCK TABLES ON `mysql`.* TO 'dump'@'%'
GRANT SELECT, LOCK TABLES ON `...
- 2,554
24
votes
1
answer
56k
views
How to grant all privileges on views to arbitrary user
How do you grant read/select access on all functions and views to an arbitrary user?
I use psql --user=postgres -d mydb -f myview.sql to create several functions and views, and then I run:
GRANT ALL ...
- 65.6k
138
votes
11
answers
157k
views
MySQL/Amazon RDS error: "you do not have SUPER privileges..."
I'm attempting to copy my mysql database from an Amazon EC2 to an RDS:
I successfully did a mysqldump of my database into my root folder using this:
root@ip-xx-xx-xx-xx:~# mysqldump my_database -u ...
- 24.4k
42
votes
3
answers
71k
views
`GRANT FILE ON` just one database
I want to allow LOAD DATA command for the john mysql user. So I logged into mysql terminal as root and issued the following statement:
GRANT FILE ON johndatabase.* TO 'john'@'localhost';
But I got ...
- 33.9k
30
votes
7
answers
101k
views
Can you limit access to only one table in a SQL Server database?
I'm looking to give someone access to a SQL Server database but I only really want them to have access to one table.
It's easy enough to limit someone to only access one database, but I have no idea ...
- 814
6
votes
4
answers
30k
views
Execute Immediate fails even with CREATE table grant
I have a problem where I am creating a table using the execute immediate command in the stored procedure. However I get the error of "insufficient privileges". I checked other threads and made sure ...
- 431
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 ...
- 2,871
23
votes
4
answers
36k
views
Grant privileges on several tables with specific prefix
I'm using the table prefix method for having several clients use the same database. The number of tables created per client will be ~55. Instead of doing all of the granting by manually listing out ...
- 714
137
votes
7
answers
175k
views
Query grants for a table in postgres
How can I query all GRANTS granted to an object in postgres?
For example I have table "mytable":
GRANT SELECT, INSERT ON mytable TO user1
GRANT UPDATE ON mytable TO user2
I need somthing which ...
- 6,618
57
votes
5
answers
93k
views
Why is GRANT not working in MySQL?
I'm scratching my head on this one as I see a ton of helper websites showing how to create MySQL users and grant privileges but for some reason it just does not work for me. I tried on both WinXP and ...
- 6,106
15
votes
5
answers
223k
views
Granting Rights on Stored Procedure to another user of Oracle
I am a student of Undergraduate studies , and I am facing little problem in granting rights of ownership to a user A to a stored procedure being owned by user B in database Oracle 10g mode =xe.
...
- 899
4
votes
4
answers
25k
views
MySql grant user permission
I want to create a new user in MySql. I do not want that new user to do much with my existing databases [I just want to grant Select privilege to him], but he can do anything and everything with a new ...
- 1,233
33
votes
2
answers
45k
views
GRANT syntax for domain\user
I'm trying to give access to an active directory user to only one specific table. I want them to be able to insert, update, delete, etc. but only for that table. I know this command:
GRANT Insert, ...
- 435
15
votes
3
answers
16k
views
Cannot grant privileges to a user using root on mysql
I am trying to give explicit permissions to an user on mysql and im doing this (to an already created user)
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, ALTER, SHOW DATABASES,
CREATE ...
- 5,908
9
votes
1
answer
59k
views
create synonym ora-01031 insufficient privileges
I need help understanding what grants/privileges a user needs to CREATE a SYNONYM when it points to another (different) schema object.
When I try the below, I get ora-01031 insufficient privileges, ...
- 193
8
votes
1
answer
3k
views
postgresql 9.1 - access tables through functions
I have 3 roles: superuser, poweruser and user. I have table "data" and functions data_select and data_insert.
Now I would like to define, that only superuser can access table "data". Poweruser and ...
- 159
6
votes
3
answers
5k
views
Can wildcards be used on tablenames for a GRANT in MySQL
Is it possible in MySQL to do a GRANT to a user on a set of tables within a database, e.g. to allow CREATE AND DROP ing of some table names but not others?
Neither of these seem to work:
GRANT ...
- 1,662
5
votes
1
answer
7k
views
Postgres. How to grant SELECT permissions automatically for new tables?
I am setting up a Postgres DB (AWS/RDS) with multiple schemas and want to have granular access control.
Each schema correlates to an application. Typically an application will have a "write" user (...
- 385
0
votes
1
answer
542
views
Not able to select a table even if having SELECT privilege
I have two users, USER1 and USER2. USER1 has privilege to create table and USER2 does not have this privilege.
USER1 has created a table called EMPLOYEE and granted the select privilege on that table ...
- 10.1k
0
votes
1
answer
827
views
How can i see if an owner has permissions to execute a Store Procedure in Oracle
I need to validate if my owner has permissions to execute a store procedure, but i have to do it searching on a sys table. In which table i can find it.
Thank you!!
