Home
All Oracle Error Codes
Oracle DBA Forum

Frequent Oracle Errors

TNS:could not resolve the connect identifier specified
Backtrace message unwound by exceptions
invalid identifier
PL/SQL compilation error
internal error
missing expression
table or view does not exist
end-of-file on communication channel
TNS:listener unknown in connect descriptor
insufficient privileges
PL/SQL: numeric or value error string
TNS:protocol adapter error
ORACLE not available
target host or object does not exist
invalid number
unable to allocate string bytes of shared memory
resource busy and acquire with NOWAIT specified
error occurred at recursive SQL level string
ORACLE initialization or shutdown in progress
archiver error. Connect internal only, until freed
snapshot too old
unable to extend temp segment by string in tablespace
Credential retrieval failed
missing or invalid option
invalid username/password; logon denied
unable to create INITIAL extent for segment
out of process memory when trying to allocate string bytes
shared memory realm does not exist
cannot insert NULL
TNS:unable to connect to destination
remote database not found ora-02019
exception encountered: core dump
inconsistent datatypes
no data found
TNS:operation timed out
PL/SQL: could not find program
existing state of packages has been discarded
maximum number of processes exceeded
error signaled in parallel query server
ORACLE instance terminated. Disconnection forced
TNS:packet writer failure
see ORA-12699
missing right parenthesis
name is already used by an existing object
cannot identify/lock data file
invalid file operation
quoted string not properly terminated

Re: Using a trigger to turn on tracing

Pete Finnigan

2004-02-13

Replies:
Hi peter,

Not a direct answer to your question as i believe the answer to have
already been given, "alter session"

If you go to my site i have a script that lists out all the privileges
granted to a user including system, object and role privs. It also
prints out hierarchically those privileges granted through roles. It can
print out its results to either the screen or to a file. Follow the
prompts. I thought you might like it to check your user and whether the
privileges are granted direct or through a role. Here is an example for
the user OUTLN:

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Feb 13 22:21:27 2004

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Personal Oracle9i Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> @find_all_privs.sql
FIND_ALL_PRIVS: Release 1.3.0.0.0 - Production -
(http://www.petefinnigan.com)
Copyright (c) 2004 PeteFinnigan.com Limited. All rights reserved.

get user input

NAME OF USER TO CHECK  [ORCL]: OUTLN
OUTPUT METHOD Screen/File [S]:
FILE NAME FOR OUTPUT  [priv.lst]:
OUTPUT DIRECTORY       [/tmp]:

    USER => OUTLN has ROLE CONNECT which contains =>
          SYS PRIV =>ALTER SESSION grantable => NO
          SYS PRIV =>CREATE CLUSTER grantable => NO
          SYS PRIV =>CREATE DATABASE LINK grantable => NO
          SYS PRIV =>CREATE SEQUENCE grantable => NO
          SYS PRIV =>CREATE SESSION grantable => NO
          SYS PRIV =>CREATE SYNONYM grantable => NO
          SYS PRIV =>CREATE TABLE grantable => NO
          SYS PRIV =>CREATE VIEW grantable => NO
    USER => OUTLN has ROLE RESOURCE which contains =>
          SYS PRIV =>CREATE CLUSTER grantable => NO
          SYS PRIV =>CREATE INDEXTYPE grantable => NO
          SYS PRIV =>CREATE OPERATOR grantable => NO
          SYS PRIV =>CREATE PROCEDURE grantable => NO
          SYS PRIV =>CREATE SEQUENCE grantable => NO
          SYS PRIV =>CREATE TABLE grantable => NO
          SYS PRIV =>CREATE TRIGGER grantable => NO
          SYS PRIV =>CREATE TYPE grantable => NO
    SYS PRIV =>EXECUTE ANY PROCEDURE grantable => NO
    SYS PRIV =>UNLIMITED TABLESPACE grantable => NO
    TABLE PRIV =>EXECUTE table_name => OUTLN_PKG grantable => NO

PL/SQL procedure successfully completed.

SQL>

hth

Kind regards

Pete
--
Pete Finnigan
email:pete@(protected)
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@(protected)
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------