sql-grant Questions
7
Solved
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 ...
Brightman asked 22/6, 2011 at 3:26
4
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...
Afflux asked 4/9, 2011 at 17:55
6
Solved
What is the grant option/trick I need to give to the current user ("userA") to allow him to change a object's owner which belongs by another user ("userC")?
More precisely, the ...
Cheliform asked 18/2, 2015 at 13:19
13
Solved
I tried to run simple SQL command:
SELECT * FROM site_adzone;
And I got this error:
ERROR: permission denied for relation site_adzone
What could be the problem here?
I tried also to do select fo...
Arcade asked 20/3, 2013 at 10:0
10
Solved
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 -...
Alyss asked 22/7, 2012 at 15:49
3
Solved
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 TEMP...
Garamond asked 23/11, 2017 at 17:17
3
Solved
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...
Calculous asked 25/11, 2012 at 15:0
10
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?...
Stigmatism asked 12/11, 2009 at 6:10
4
Solved
I'm trying to create a Postgres database for the first time.
I assigned basic read-only permissions to the DB role that must access the database from my PHP scripts, and I have a curiosity: If I ex...
Tepper asked 27/6, 2013 at 8:46
2
Solved
I created a user (new_user) with root like this:
GRANT ALL ON labor.* TO 'new_user'@'%' WITH GRANT OPTION;
GRANT ALL ON labor.* TO 'new_user'@'localhost' WITH GRANT OPTION;
GRANT CREATE USER ON *....
Amaty asked 3/9, 2013 at 12:55
8
Solved
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 s...
Swinson asked 18/3, 2014 at 15:16
4
somewhere along the way something is going wrong, and I can't seem to find out why. If this is already asked apologies.
I have 3 schema's in my database:
COLLDESK
LOCAL_IT
GERBEN
COLLDESK is our ...
Byzantium asked 19/6, 2014 at 13:31
7
Solved
I need to see all grants on an Oracle DB.
I used the TOAD feature to compare schemas but it does not shows temptable grants etc. so there's my question:
How can I list all grants on a Oracle DB?
...
2
Solved
In my windows forms application I use Mysql to get data. (I use MySql.Data.dll)
Here is my connection string:
server=xxx.xxx.xxx.xxx;user id=user_name;Password=userpass;database=products
When I...
Keil asked 19/3, 2014 at 9:19
2
I want to grant select privilege to user from every host, but getting an error, you're not allow to create a user
mysql>GRANT SELECT ON *.* TO 'alice'@'%' WITH GRANT OPTION;
ERROR 1410 (42000):...
23
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 ...
1
Solved
Database "mydb" is owned by role "mydb_owner".
User "currentuser" tries to delete role "roletodelete" from this database using
revoke all on all tables in schema public,firma1 from "roletodelet...
Outline asked 12/4, 2020 at 8:15
7
Solved
I think the answer is no but 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 o...
Hydro asked 20/3, 2012 at 12:48
3
Solved
Is there a way to grant all privileges to a user on Oracle schema? I tried the following command but it only grants permission on specific tables in a schema. What I want is to give this user all p...
Hydrastis asked 8/12, 2014 at 7:55
5
I often see in many MySQL tutorials that people use command IDENTIFIED BY 'password' both during user creation and granting him privileges.
For example:
CREATE USER 'username'@'localhost' IDENTI...
Ammonic asked 29/6, 2015 at 9:12
2
Solved
I am deploying a database in postgreSQL and I created a user that just will be able to execute certain functions.
I revoked all privileges from the user i just created and granted connect privileg...
Veradia asked 11/7, 2013 at 16:25
3
I searched and read android developer files but I did not find any satisfactory answer for content provider grant uri permission. Can anybody explain more detailed and more simple. My questions are...
Boelter asked 10/4, 2014 at 13:58
3
Solved
I am trying to give a user permission to run a stored procedure at the stored procedure level on a MySQL Database rather than allowing a user to execute any stored procedure in the database. I was ...
Archdeaconry asked 10/4, 2012 at 13:0
8
Solved
I can easily grant access to one IP using this code:
$ mysql -u root -p
Enter password:
mysql> use mysql
mysql> GRANT ALL ON *.* to root@'192.168.1.4' IDENTIFIED BY 'your-root-password';
...
1
In MariaDB I am having this warning in the error log. Is there a way to resolve the issue without knowing the user name?
[Warning] Aborted connection 1101 to db: 'unconnected' user: 'unauthenticate...
1 Next >
© 2022 - 2025 — McMap. All rights reserved.