oracle注销用户,用户自动注销时间设置

默认三分钟不操作自动退出：

SQLSERVER

delete from gspuserconfig where CONFIGKEY1 =  'AutoExit.Enabled'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, BOOLVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(NEWID(),'*','AutoExit.Enabled','AutoExit.Enabled','1','1',GETDATE())

GO

delete from gspuserconfig where CONFIGKEY1 =  'Lock.Enabled'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, BOOLVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(NEWID(),'*','Lock.Enabled','Lock.Enabled','0','1',GETDATE())

GO

ORACLE

delete from gspuserconfig where  CONFIGKEY1 = 'AutoExit.Enabled'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, BOOLVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(sys_guid(),'*', 'AutoExit.Enabled', 'AutoExit.Enabled','1','1',sysdate)

GO

delete from gspuserconfig where  CONFIGKEY1 = 'Lock.Enabled'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, BOOLVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(sys_guid(),'*', 'Lock.Enabled', 'Lock.Enabled','0','1',sysdate)

GO

默认三分钟不操作自动锁屏：

SQLSERVER

delete from gspuserconfig where CONFIGKEY1 =  'AutoExit.Enabled'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, BOOLVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(NEWID(),'*','AutoExit.Enabled','AutoExit.Enabled','0','1',GETDATE())

GO

delete from gspuserconfig where CONFIGKEY1 =  'Lock.Enabled'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, BOOLVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(NEWID(),'*','Lock.Enabled','Lock.Enabled','1','1',GETDATE())

GO

ORACLE

delete from gspuserconfig where  CONFIGKEY1 = 'AutoExit.Enabled'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, BOOLVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(sys_guid(),'*', 'AutoExit.Enabled', 'AutoExit.Enabled','0','1',sysdate)

GO

delete from gspuserconfig where  CONFIGKEY1 = 'Lock.Enabled'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, BOOLVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(sys_guid(),'*', 'Lock.Enabled', 'Lock.Enabled','1','1',sysdate)

GO

自动退出时间配置

XXXXXXX 代表想要设置的自动退出的间隔时间

SQLSERVER

delete from gspuserconfig where CONFIGKEY1 =  'AutoExit.Interval'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, LONGVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(NEWID(),'*', 'AutoExit.Interval', 'AutoExit.Interval','XXXXXXX','1',GETDATE())

GO

ORACLE

delete from gspuserconfig where  CONFIGKEY1 =   'AutoExit.Interval'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, LONGVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(sys_guid(),'*', 'AutoExit.Interval', 'AutoExit.Interval','XXXXXXX','1',sysdate)

GO

自动锁屏时间配置

XXXXXXX 代表想要设置的自动锁屏的间隔时间

SQLSERVER

delete from gspuserconfig where CONFIGKEY1 =  'Lock.Interval'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, LONGVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(NEWID(),'*', 'Lock.Interval', 'Lock.Interval','XXXXXXX','1',GETDATE())

GO

ORACLE

delete from gspuserconfig where  CONFIGKEY1 =   'Lock.Interval'

go

INSERT INTO GSPUSERCONFIG (ID,USERID,CONFIGNAME,CONFIGKEY1, LONGVALUE,ISSYSDEFAULT,LASTMODITYTIME)

VALUES(sys_guid(),'*', 'Lock.Interval', 'Lock.Interval','XXXXXXX','1',sysdate)

GO