0

I'm writing a script which weekly updates the users who have access to a database (all users from a specific group in our AD).

In my script I have to authenticate me as an user with the privileges to create users and to grant them privileges.

I dislike using the root user (and his plaintext password!) in a script, so I hope to create a dummyuser with as little as possible privileges, I want to reduce the security risk.

Is there a possible way and will it be secure? Which privileges will this dummyuser need?

  • Please add the script you are using/writing. – Ahmad Abuhasna Feb 8 '16 at 13:12
0

create a user with grant option privilege.

GRANT [whatever privilege to that normal user] TO 'normal_user'@'ipaddress' WITH GRANT OPTION IDENTIFIED BY 'password'; FLUSH PRIVILEGES;

| improve this answer | |

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.