Post reply

Can I block specific rows in a table?

  • June 26, 2009 at 12:56 am

    #201840

    Can I block specific records for a login? Something like:

    SELECT c1, c2, c3 FROM Table1

    WHERE c3 = 'ABC'

    I can do this with a view, which said login can READ, but that would mean changing an interface, which adresses the table.

    Greetz,
    Hans Brouwer

  • June 26, 2009 at 1:01 am

    #1015801

    FreeHansje (6/26/2009)

    Can I block specific records for a login? Something like:

    SELECT c1, c2, c3 FROM Table1

    WHERE c3 = 'ABC'

    I can do this with a view, which said login can READ, but that would mean changing an interface, which adresses the table.

    I doubt there is option to do horizontal filtering to a table for a specific login. creating a view is the only option i guess.


    Pradeep Singh

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

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