Hello All,
my database contains a big table. on this table I create VIEWs.
The problem is this: the VIEWs are created dinamically by an external
program (depending on some configurations). Nevertheless I would like to
GRANT SELECT priviliges to my readOnlyUser, in a simple way...!!!
Summary: is it possible to allow Read-Onlky access to some user, in some
database, even if new database objects (VIEWs in my case) are created
dinamically ???
something like
GRANT SELECT ON * TO readOnlyUser;
I'm confused..
thx
jmf
DISCLAIMER: This message may contain confidential information or privileged material and is intended only for the
individual(s)named. If you are not a named addressee and mistakenly received this message you should not copy or
otherwisedisseminate it: please delete this e-mail from your system and notify the sender immediately. E-mail
transmissionsare not guaranteed to be secure or without errors as information could be intercepted, corrupted, lost,
destroyed,arrive late or incomplete or contain viruses. Therefore, the sender does not accept liability for any errors
oromissions in the contents of this message that arise as a result of e-mail transmissions. Please request a hard copy
versionif verification is required. Critical Software, SA.