The privileges tag has no wiki summary.
0
votes
2answers
38 views
Why does this procedure raise a privilege error?
I am having trouble getting the following procedure to run on a remote MySQL database - the given error is privilege based (#1227). Locally, the procedure runs fine.
QUESTIONS
Could somebody help ...
1
vote
1answer
123 views
ORA-16000 when trying to perform select on read only access ORACLE database
My application's SQL encounters ORA-16000 when trying to access read only Oracle Database
ORA-16000: database open for read-only access ORA-06512: at "SYS.XMLTYPE",
line 272 ORA-06512: at line 1 ### ...
1
vote
1answer
42 views
Can't SHOW GRANTS after MySQL re-install
I had to completely re-install MySQL on one of the slaves and then rebuild it via a sql dump (we have 1 master and 2 slaves). I tried to SHOW GRANTS for one of the users, but keep getting the ...
1
vote
0answers
68 views
User defined content specific permissions with varying conditions. How to design tables?
I'm working on a privacy settings problem, which is proving to be cumbersome to design.
Essentially I have:
User created content
User can define access groups for content.
Access groups vary ...
0
votes
0answers
10 views
hosting account with advanced mysql privileges
Is it possible to have a mysql database where either:
a) the user has limited permissions on a table by table basis (e.g. can only select, insert from table_a, and can only update table_b)
b) ...
0
votes
0answers
61 views
Unable to set table-specific privileges
I want to give a user access to only a few tables. I execute this query:
GRANT SELECT (credits_features_csgo, steam_code, credits_csgo, userid,
credits_forum, credits_features_tf2, credits_tf2, ...
0
votes
0answers
37 views
Give privilege to new created databases in MySQL
I have user "U" who I want to give him full access to all the existing databases except "db1". I want him to only have select privilege for that db. What I did is I gave "U" all permissions for each ...
