grant select on table.field1,table.field2 to public;
create role role1;
grant grant select on table.field1,table.field2,table.field3,table.field4 to role role1;
create role role1;
grant grant select on table.field1,table.field2,table.field3,table.field4 to role role1;
解决方案 »
- 奇怪问题,oracle不能做插入操作,可以查询。有谁遇到过ORA-01110,求解!!
- 错误:Process PZ99 died, see its trace file请高手指点
- 令人头疼的RAC安装
- 【求助】:oracle 监听启动失败,TNS-01189: The listener could not authenticate the user
- oracle 中能不能判断这个字段中是数字还是字符
- 求助:redo log切换时本地磁盘占用率高
- 十分着急,请大家帮我,关于序列的.
- 比武招亲!
- 游标变量
- sql问题求思路,
- 谁有dbms_output包的资料,兄弟我高分相送!!
- 请问如何截取两个sysdate之间的间隔秒数啊?
as
begin
if p_role=... then --有权限
select * from tab; --此处要用游标实行.
else --没有权限
select Field1,Field2 from tab;
end if;
end;
/
create view viewname1 as select field1,filed2 from tablename;
create view viewname2 as select field1,filed2,field3... from tablename;
grant select on viewname1 to role1;
grant select on viewname2 to role2;