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
Anatol
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).

Report message to a moderator

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.

Report message to a moderator

Previous Topic: Duplicated object
Next Topic: Difficulty Framing a Query
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 25 18:09:55 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.