create or replace procedure sp_page(AllCount OUT NUMBER,
ResultSet OUT PagePack.PageCursor,
PageCurrent IN NUMBER,
PageSize IN NUMBER,
Fields IN VARCHAR,
Condition IN VARCHAR,
OrderGroup IN VARCHAR,
IsCount IN NUMBER)
Authid Current_User
as
pageindex number;
psize number;
sqlstr varchar2(1000);
sqlcomm varchar2(1000);
BEGIN
只需要创建存储过程中使用Authid Current_User赋值就即。
手动赋值可能赋不全,可参照以下:
以sys as sysdba身份登陆(命令窗口运行),显式赋予
grant select on dba_data_files to userName
grant select on dba_free_space to userName
grant select on dba_free_space_coalesced to userName