Re: ORA-00942: How can access a table without pre-fixing the schema name

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 14 Jul 2005 10:34:53 +0200
Message-ID: <42d624a5$0$16824$9b4e6d93@newsread2.arcor-online.net>

baka schrieb:
> Thank you very much max(Guru) san
> First You hacked me. then you solved my problem.
> but one more thing , if I use that functionality.
> what are security implications ? if any ..
> Sorry for troubleing again
> Thanks in Advance
> baka
>

AFAIK you change with "alter session set current_schema" only naming context of database objects, all your security context is still valid ( i.e. you can see only things ruser may see and you can do only things ruser may do ).

Best regards

Maxim Received on Thu Jul 14 2005 - 03:34:53 CDT

This message: [ Message body ]
Next message: chao_ping: "Re: optimizer_features_enable difference between 9.2.0.1/9..2.0.3/9.2.0.6?"
Previous message: Holger Baer: "Re: EXEC syntax for SP which returns row set"
In reply to: baka: "Re: ORA-00942: How can access a table without pre-fixing the schema name"
Next in thread: Phil: "Re: ORA-00942: How can access a table without pre-fixing the schema name"
Reply: Phil: "Re: ORA-00942: How can access a table without pre-fixing the schema name"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US