Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - ssharma

Pages: [1]
1
PSOUG / SELECT on a sequence and nextval
« on: September 23, 2009, 09:44:01 AM »
Is it possible to grant SELECT on a sequence to a user (readonly user), but user should not be able to increment the sequence by using nextval on that sequence?

 Because if it does so, the user is not "readonly".

2
PSOUG / Re: ORA-29280: invalid directory path
« on: September 23, 2009, 09:39:32 AM »
See if you have done this after creating directory object?

grant read, write on directory ORALOAD to <user>;

Pages: [1]