注册

select CURRENT_USERTYPE() 函数返回的值有什么含义

Live 2021/07/13 1332 7

为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:DM8
【操作系统】:centos7
【CPU】:16
【问题描述】*:1.select CURRENT_USERTYPE() 函数返回的值有什么含义?有没有具有相关表的字段可参考?
image.png

2.SF_CHECK_PRIV_OPT函数有六个传参,各是什么含义?
image.png

3.达梦管理工具当只给普通用户授予一个表的某些列权限时,左侧列表不展示。只有当全部列权限都有才会展示出来。即左侧树列权限不能对应展示。
grant select(c_bh,c_mc) on person.t_owner to ywry;

select
tab_obj_out.,
comment_obj.comment$
from
(
select
/
+OPTIMIZER_OR_NBEXP(2)/
TAB_OBJ.NAME ,
TAB_OBJ.ID ,
TAB_OBJ.SUBTYPE$ ,
TAB_OBJ.INFO3 ,
TAB_OBJ.SCHID ,
SCH_OBJ.NAME SCHNAME ,
TAB_OBJ.CRTDATE ,
INFO8 ,
TAB_OBJ.INFO2
(PAGE/1024)/1024,
TAB_OBJ.INFO1
from
(
select
TAB_OBJ_INNER.NAME ,
TAB_OBJ_INNER.ID ,
TAB_OBJ_INNER.SUBTYPE$,
TAB_OBJ_INNER.INFO1 ,
TAB_OBJ_INNER.INFO2 ,
TAB_OBJ_INNER.INFO3 ,
TAB_OBJ_INNER.INFO8 ,
TAB_OBJ_INNER.SCHID ,
TAB_OBJ_INNER.CRTDATE
from
SYS.SYSOBJECTS TAB_OBJ_INNER,
SYS.SYSOBJECTS SCH_OBJ_INNER,
SYS.SYSOBJECTS USER_OBJ_INNER
where
TAB_OBJ_INNER.type$ = ‘SCHOBJ’
and TAB_OBJ_INNER.INFO3&0x100000!=0x100000
and TAB_OBJ_INNER.INFO3&0x200000!=0x200000
and TAB_OBJ_INNER.INFO3 & 0x003F not in (0x0A, 0x20)
and
(
TAB_OBJ_INNER.INFO3 & 0x100000000
)
= 0
and TAB_OBJ_INNER.NAME not like ‘CTI$%$_’
and TAB_OBJ_INNER.NAME not like ‘%$AUX’
and TAB_OBJ_INNER.NAME not like ‘%$_AUX’
and TAB_OBJ_INNER.NAME not like ‘%$ALOG’
and TAB_OBJ_INNER.SUBTYPE$ = ‘UTAB’
and
(
TAB_OBJ_INNER.PID=-1
or TAB_OBJ_INNER.PID=0
)
and TAB_OBJ_INNER.INFO3 & 0x003F != 13
and TAB_OBJ_INNER.SCHID = 150995947
and USER_OBJ_INNER.SUBTYPE$ = ‘USER’
and SCH_OBJ_INNER.ID = TAB_OBJ_INNER.SCHID
and SCH_OBJ_INNER.PID = USER_OBJ_INNER.ID
and SF_CHECK_PRIV_OPT(UID(), CURRENT_USERTYPE(), TAB_OBJ_INNER.ID, USER_OBJ_INNER.ID, USER_OBJ_INNER.INFO1, TAB_OBJ_INNER.ID) = 1
)
TAB_OBJ,
(
select ID, NAME from SYS.SYSOBJECTS where TYPE$=‘SCH’ and ID = 150995947
)
SCH_OBJ
where
TAB_OBJ.SCHID=SCH_OBJ.ID
)
TAB_OBJ_OUT
LEFT JOIN SYS.SYSTABLECOMMENTS COMMENT_OBJ
ON
TAB_OBJ_OUT.NAME = COMMENT_OBJ.TVNAME
AND TAB_OBJ_OUT.SCHNAME = COMMENT_OBJ.SCHNAME
order by
TAB_OBJ_OUT.NAME;

回答 0
暂无回答
扫一扫
联系客服