oracle DB, which user privileges do I have?

select * from SESSION_PRIVS;

CREATE SESSION
CREATE TABLE
CREATE VIEW
CREATE SEQUENCE
CREATE PROCEDURE
CREATE MATERIALIZED VIEW
CREATE TYPE
MANAGE ANY QUEUE
ENQUEUE ANY QUEUE
DEQUEUE ANY QUEUE
CREATE EVALUATION CONTEXT
CREATE RULE SET
CREATE RULE
CREATE JOB



To assign a privilege to user PIPPO:

GRANT CREATE JOB to PIPPO;

see also

http://docs.oracle.com/cd/B10500_01/server.920/a96521/privs.htm