about EXECUTE IMMEDIATE question

boy002 2003-09-01 10:02:41

请问怎样给用户执行EXECUTE IMMEDIATE 命令的权利？
谢谢..

...全文

71 2 打赏收藏转发到动态举报

写回复

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

beckhambobo 2003-09-02

打赏
举报

回复

例如:
execute immediate 'create table a (id varchar2(10))';

此句就要相应create any table权限
grant create any table to user_name

beckhambobo 2003-09-01

打赏
举报

回复

是一个命令,不用赋权限，对应的权限，再给予赋权限

The lock manager knows nothing about the resource format. It simply compares the 'strings' representing the lock resources to determine whether it has found a match. If a match is found, it knows that...

A question we often see is "I have a lot of blank lines in my file and I don't want to go through and manually delete them. Is there an easier way to do this?" The answer is: yes! Configure FTP Set up...

oracle 存储过程中，使用execute immediate 来执行动态SQL，每次都会发生硬解析吗？中文社区 (MOSC)数据库 (MOSC)6 RepliesLast updated on October 08, 2013This question is Not Answered.使用execute immediate ...

1.What New Skills Can I Hope to Learn Here?... This is just my perspective, but I've always secretly hoped to hear this question. It signifies a few positive things: the applicant acknowledges

EXECUTE IMMEDIATE :Mysql USING SQLCA; //2.有输入参数、但没有结果集 int Emp_id_var = 56 PREPARE SQLSA FROM "DELETE FROM employee WHERE emp_id=?" ; EXECUTE SQLSA USING :Emp_id_var ; //3.编译时...

Oracle 高级技术

3,494

社区成员

18,710

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章