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 otherwise disseminate it: please delete this e-mail from your system and notify the sender immediately. E-mail transmissions are 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 or omissions in the contents of this message that arise as a result of e-mail transmissions. Please request a hard copy version if verification is required. Critical Software, SA.
