Can show trigger be granted without the update trigger credential in Aurora or m

Question

Post reply

Can show trigger be granted without the update trigger credential in Aurora or m

hendersh

SSC Rookie

Points: 32
More actions
June 14, 2022 at 6:02 pm

#4049431

Can show trigger be granted without the update trigger credential in Aurora or mysql

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Johan Bijnens SSC Guru Points: 135382 More actions · Answer 1

I don't know for Aurora and mysql

In SQLServer you can just use "GRANT view definition TO ..."

Johan

Learn to play, play to learn !

Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:

- How to post Performance Problems
- How to post data/code to get the best help[/url]

- How to prevent a sore throat after hours of presenting ppt

press F1 for solution, press shift+F1 for urgent solution 😀

Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me

frederico_fonseca SSCoach Points: 16183 More actions · Answer 2

from what I can see on documentation you can't grant the view alone - in order to allow a user to view the definition you must also give the same user permission to create the trigger in the first place - see https://dev.mysql.com/doc/refman/8.0/en/show-create-trigger.html