OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Permission

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Permission [message #374045]

Tue, 22 May 2001 10:12

Sue
Messages: 49
Registered: May 2000

Member

Hi,
How do I find what permission do I have .

Thanks,
Sue

Report message to a moderator

Re: Permission [message #374048 is a reply to message #374045]

Tue, 22 May 2001 10:35

Hans
Messages: 42
Registered: September 2000

Member

do you mean which roles are granted to you ?

select * from session_roles;

Report message to a moderator

Re: Permission [message #374049 is a reply to message #374045]

Tue, 22 May 2001 10:49

Muhamad Sirajdin
Messages: 12
Registered: May 2001

Junior Member

select * from session_privs;

Report message to a moderator

Views performance [message #374050 is a reply to message #374049]

Tue, 22 May 2001 12:15

aish
Messages: 44
Registered: March 2001

Member

Hi,

I have views that select from different tables
The views are slow the one reason might be the view and tables are in diffenrent schema I cannot have both views and tables in the same schema bcos of the security issue.and my application uses these and it has become very slow Can anyone tell be how do I increase the speed of retriving the data?

Thanks,
Aish

Report message to a moderator

Re: Views performance [message #374054 is a reply to message #374050]

Tue, 22 May 2001 14:44

Andrew again...
Messages: 270
Registered: July 2000

Senior Member

Assuming that both schemas are on the same instance, there are two ways to reference tables not belonging to your schema (whether you use synonyms or not)
1.) Refer to it by name directly (e.g. scott.emp)
2.) Create a DB link to scott (e.d. emp@my_link)

Option 1 is better as it doesn't go out over sql*net/net8. If you are joining tables between different instances (say on different machines) then you need to use DB links. If this is the case, consider that the data in the remote tables could be being pulled across the network to enable the joins/filtering to be performed. There is a hint which forces the query to be resolved either on the local or remote side which can be used to minimised network traffic e.g.

http://www-rohan.sdsu.edu/doc/oracle/server803/A54638_01/optimiz.htm#5975

http://www-rohan.sdsu.edu/doc/oracle/server803/A54638_01/distrib.htm

Report message to a moderator

Previous Topic:	Tricky SQL statement - infinite recurstion?
Next Topic:	Re: SALMAN KHAN

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 13:14:48 CST 2024