I am trying to grant privileges for every table I have (around 1000) to another user. Im having troubles finding the syntax to do so (not experiences in SQL)
I thought it was
Grant select on * to kkp
kkp is the user i am trying to grant access to. I know this works when you do one table at once but since I have so many tables it wont work to do this one by one. I remember I have done something like this before.
I have searched everywhere so hopefully there isnt already threads on this problem.
thank you in advance for any help