Post reply

View with read only option ?

  • October 12, 2004 at 6:23 am

    #60459

    Hi,

    Is there anyway to create view with read only option as in Oracle ? (OR) is there any

    workaround for the same ?

    Please advice,

    Thanks,

    Sam

  • October 12, 2004 at 6:59 am

    #526320

    Yes,

    If you grant access via database roles then deny write access to the view for that particular role.

    If you grant access to users (after a smack on the wrist) deny write access to those users for that user.

    LinkedIn Profile

  • October 12, 2004 at 10:21 am

    #526359

    Or you just give them rights to select from the view or underlying table with granting insert, update, or delete.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply