可以在Oracle存储过程中使用GRANT吗? [英] Can GRANT be used inside an Oracle Store Procedure?

问题描述

当尝试在Oracle 11存储过程中放置​​GRANT语句时，它报告GRANT是意外的符号.是否需要在GRANT前面加上某些内容，或者Oracle是否只是不允许在SP内运行GRANTS?

When trying to place a GRANT statement in an Oracle 11 stored procedure, it reports that GRANT is an unexpected symbol. Does GRANT need to be prefaced by something, or does Oracle simply disallow running GRANTS inside SPs?

推荐答案

在存储过程中使用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.

这篇关于可以在Oracle存储过程中使用GRANT吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！