June 14, 2022 at 6:02 pm
Can show trigger be granted without the update trigger credential in Aurora or mysql
June 15, 2022 at 6:27 am
I don't know for Aurora and mysql
In SQLServer you can just use "GRANT view definition TO ..."
JohanLearn 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
June 15, 2022 at 7:21 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply