I am trying to run the query in snowflake

show grants to user username

ex: show grants to user test_account

It works if I give username as test_account but if i change it to use something like [email protected]. It fails because of @ character.

How can I make it evaluate @ character?

CodePudding user response：

the same way as you created them, with double quotes:

create user "test@account";

show grants to user "test@account";