All Questions
Tagged with php permissions
6 questions
0
votes
1
answer
313
views
How to structure MySQL database tables for users and how to handle adding/removing permissions?
I am making a database structure for users, who can become part of a group, and within that group the admin of the group can assign as many permissions to a user as they would like.
This part seems ...
3
votes
1
answer
18k
views
Simplest way to check if current user has permission to a MySQL table (from PHP / mysqli) for some desired operation?
While using an already established mysqli connection to a MySQL database from PHP, I'm looking for a simple way to check if this connection (i.e. the authenticated user for this connection, if any) ...
- 131
7
votes
1
answer
29k
views
Even after permissions are updated, I still get the error permission denied for relation users
I'm getting the error ERROR: permission denied for relation users and have tried to update privileges using both
grant all privileges on all tables in schema ops to my_user
GRANT ALL PRIVILEGES ON ...
- 173
1
vote
0
answers
578
views
What is the best way to manage user access to MySQL via PHP?
I am working on a web application that requires auditing db queries in MySQL. In every application that I have developed or worked on it is standard practice to store the DB credentials in a protected ...
- 11
0
votes
1
answer
7k
views
The UPDATE permission was denied on the object
I'm connecting to a remote Microsoft server running MsSQL via PHP. The code looks something like:
$con = mssql_connect('0.0.0.0:123', 'user', 'pass')
or die(log_mssql_error(__FILE__, __LINE__, ...
- 115
1
vote
2
answers
147
views
Cannot INSERT into database on a shared server
I have launched an application on a shared server but I cannot INSERT any data. I thought maybe I don't have privileges so I did SHOW GRANTS in my application then die()
The result was [ EDITED ]:
...
- 111