Home » SQL & PL/SQL » SQL & PL/SQL » like to know more grants
like to know more grants [message #326672] Thu, 12 June 2008 04:03 Go to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,

so far i was working with the grants of dba,resource,connection.

recently i learnt the grant on execution utl_file to user

likewise is there any other grants available can i able
to see the list of all other grants
yours
dr.s.raghunathan
Re: like to know more grants [message #326673 is a reply to message #326672] Thu, 12 June 2008 04:04 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
It took me about 25 seconds to find This

Re: like to know more grants [message #326674 is a reply to message #326673] Thu, 12 June 2008 04:11 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi jrowbottom,

many times you are offering fantastic help and this time too.
thanks... in my office net, i can not visit anyother sites
other than orafaq.com. Anyway, as soon as i go home, i will see the noted site.

Thanks a lot...

yours
dr.s.raghunathan
Re: like to know more grants [message #326682 is a reply to message #326674] Thu, 12 June 2008 04:39 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
this sounds familiar..

I remember we had someone else with this retarded net-restriction about a year (or more) ago here.
Complain!

What on earth can be the reason to block Oracle's documentation, yet allowing some arbitrary site like OraFAQ?
Re: like to know more grants [message #326685 is a reply to message #326682] Thu, 12 June 2008 04:46 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,
you made a sound thinking. for me it is still puzzling

Re: like to know more grants [message #326689 is a reply to message #326685] Thu, 12 June 2008 05:02 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
So, you went out and asked. What was there reasoning behind this?
Re: like to know more grants [message #326690 is a reply to message #326689] Thu, 12 June 2008 05:10 Go to previous message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
ours is the power generation company (public sector) using good
old oracle 7.1 with forms 4.5 and reports 3.0

lots of students are coming as project trainee (during acadamic
session) and plays mistual roal on applying the syntax based
on the docs.. without much guidance and it gives lots of problem
our security need to be strengthened.

being a partial government company it hsa got lots of procedures
to upgrade, implement security system etc.

to protect the conventional databases restricted and help sites

reply is unofficial and unauthenticated natured one
Previous Topic: can we use update and select command in single query.
Next Topic: SQL Help
Goto Forum:
  


Current Time: Sun Dec 11 07:59:36 CST 2016

Total time taken to generate the page: 0.23369 seconds