0

i am a noob and this is how far i got so far, thanks and also how would you do it if you want to allow user to grant the same privilege to another user.

GRANT SELECT ON DATABASE_NAME.* TO USER;
  • Have you tried the manual already? – Andriy M May 19 '16 at 6:50
  • @AndriyM i have already solved the issue, thanks – Op-Zyra May 20 '16 at 2:23
  • Please: either provide the solution, or delete the question. – Rick James May 29 '16 at 5:21
0

the solution was to add

    WITH GRANT OPTION;

at the end of grant command line. e.g. if i wanted to grant select privilege (+ allow user to grant the same privilege to another user), to a user called user1 for table EMPLOYEE. Here would a an appropriate command

GRANT SELECT ON DATABASENAME.EMPLOYEE TO USER1  WITH GRANT OPTION;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.