#17 user with low-permission profile create segmentation fault
select username, profile, resource_name, limit from
dba_users join dba_profiles using (profile) where limit
not in ('UNLIMITED', 'DEFAULT', 'NULL')
USERNAME PROFILE
RESOURCE_NAME LIMIT
------------------------------
------------------------------
--------------------------------
----------------------------------------
SPIROU NEWBIE
CPU_PER_CALL 1
$ gqlplus 'spirou/spirou'
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Nov 11
15:01:59 2003
Copyright (c) 1982, 2002, Oracle Corporation. All
rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
Segmentation fault
However, it is possible to connect first as another
user, then switch to this user.
$ gqlplus '/ as sysdba'
SQL*Plus: Release 9.2.0.4.0 - Production on Tue Nov 11
15:14:10 2003
Copyright (c) 1982, 2002, Oracle Corporation. All
rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production
SQL> conn spirou/spirou
Connected.
SQL> select * from dual;
D
-
X
SQL> quit
