Interesting comment. So if I understand what you are
saying I should be able to create a user:

SQL> create user nottoosmart identified by
d0ntkn0wmuch;

User created.

SQL> grant create session to nottoosmart;

Grant succeeded.

SQL> connect nottoosmart/d0ntkn0wmuch
Connected.
SQL> alter session set events '10046 trace name
context forever level 16';
ERROR:
ORA-01031: insufficient privileges

Hmm - would you mind posting your EXACT test case? I
ran this against a 9.2.0.7, 10.2.0.1 and 10.2.0.2
database and seem to get different results then you
are seeing.  Just for the heck of it I went ahead and
granted the user alter session privileges:

SQL> conn / as sysdba
Connected.
SQL> grant alter session to nottoosmart;

Grant succeeded.

SQL> connect nottoosmart/d0ntkn0wmuch
Connected.
SQL> alter session set events '10046 trace name
context forever level 16';
ERROR:
ORA-02194: event specification syntax error 230 (minor
error 215) near 'LEVEL'

so even a user that I've purposely given privileges to
alter their own session doesn't seem to be able to do
anything with this command.

So far I have to call this myth: Busted

---Original message----
I can't believe it. Oracle releases new patches and
they have not been solved one of the main problems: A
user with only the SELECT privilege can do WHATEVER
(S)HE WANTS WITH THE ENTIRE DATABASE!!!!

I'm not sure if is time to full disclosure it but,
anyway, I will "full disclosure" one inocent issue, an
integer overflow:

Example:
--Connect with any user with only CREATE SESSION
SQL> alter session set events '10046 trace name
context forever, level 
SQL> 16';

Session altered.

SQL> alter session set events
'10046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004610046100461004
61004610046100461004610046100461004610046100461004610046100461004610046100461004610046trace
name context forever, level 16';
ERROR:
ORA-00600: internal error code, arguments: [300],
[985], [], [], [], [], [], []


It's not even a crash but (be sure) that there are
other "combinations" that makes it vulnerable to
integer overflows allowing the execution of arbritrary
code.

PD: Hello Mary Ann! Are you on holidays?

_________________________________________________________________
Grandes =E9xitos, superh=E9roes, imitaciones, cine y TV...

http://es.msn.kiwee.com/ Lo mejor para tu m=F3vil. 

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com