Home » SQL & PL/SQL » SQL & PL/SQL » Restricting to update some rows in table
Restricting to update some rows in table [message #37345] Fri, 01 February 2002 06:52 Go to next message
Messages: 15
Registered: January 2002
Junior Member
How I can determine names of users which execute my procedure dinamically (I want to restrict to some of them to update some rows in table).
Re: Restricting to update some rows in table [message #37352 is a reply to message #37345] Fri, 01 February 2002 10:53 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
reference the pseudo column "user" anywhere in your code - it's just like sysdate in that respect. You could also code this into a trigger on your table so that even if access isn't through your proc you could still block it.
In recent Oracle versions you can also use fine grained access - but that would be lots of work for you.
Previous Topic: Duplicated object
Next Topic: Difficulty Framing a Query
Goto Forum:

Current Time: Wed May 22 15:33:00 CDT 2024