Disabling (Set) Role under SQL*DBA
Date: 6 Feb 1995 22:40:09 GMT
Message-ID: <3h68g9$g3g_at_CUBoulder.Colorado.EDU>
Hi DBAs!
I am a new dba, and hope that someone can help me out.
Disabling SQL*Plus commands, like set, set role, and disabling roles
under SQL*Plus work fine if I put a record in PRODUCT_USER_PROFILE.
But they seems not work under SQL*DBA. I tried most conbinations,
such as:
insert into product_user_profile(product,userid,attribute,char_value)
values('SQL*Dba','USER1','SET ROLE','DISABLED');
insert into product_user_profile(product,userid,attribute,char_value)
values('SQL*DBA','USER1','SET ROLE','DISABLED');
insert into product_user_profile(product,userid,attribute,char_value)
values('SQL*Dba','USER1','ROLES','role1');
insert into product_user_profile(product,userid,attribute,char_value)
values('SQL*DBA','USER1','ROLES','role1');
insert into product_user_profile(product,userid,attribute,char_value)
values('SQL*Dba','USER1','SET','DISABLED');
I also tried to change SQL*Dba and SQL*DBA to SQL*Plus, and then use SQL*DBA to set role. Still CAN USE SET ROLE.
SO, how can I prevent my OS/2 clients who have SQL*DBA to use set role?
Please email me if/when possible.
Thanx in advance! Received on Mon Feb 06 1995 - 23:40:09 CET