在存储过程中使用DDL(如GRANT)是个坏主意.

It's a bad idea to use DDL (like GRANT) inside stored procedures.

您将必须使用动态SQL(EXECUTE IMMEDIATE)来执行此操作，但是，老实说，我不明白为什么要在存储的proc中执行此操作.

You will have to use dynamic SQL (EXECUTE IMMEDIATE) to do this, but, honestly, I don't see why would you want to do this inside a stored proc.