Hi, I have a password to a database with all the databse privileges, except reload, shutdown, process, file and with Grant options.
This is the administrator or super user password, with most of the privileges. Someone else has created the data base. Now I'll maintain it. I need to add a new user with select privilege. I tried with "FLUSH PRIVILEGES", BUT THE SYSTEM GIVES THE ERROR: ACEESS DENIED. yOU NEED THE RELOAD PRIVILEGE FOR THIS OPERATION." How can I add a new user, when I don't have a grant option privilege? any insights are greatly appreciated. TIA. Sheela Lakshmi