On 7/27/06, Satheesh Bandaram <[EMAIL PROTECTED]> wrote:
Yes, for an extent database, you have to upgrade the database to 10.2 and then set the sqlAuthorization property as a database property to turn on SQL authorization.
Thanks for clarifying this Satheesh. I tried this by setting it as a database property for the upgraded database. However, grant/revoke does not work right away. It works after I shutdown/reconnect to the database. Is this the expected behaviour for this property? If so, it may be good to add this to the spec and documentation. Thanks, Deepa
