This topic is locked

Selective Field view

12/11/2006 1:44:10 PM
ASPRunnerPro General questions
D
dunga author

I have a table with 12 fields
I would like to accomplish this:
when user1 logs in he can only see 9 fields
when user2 logs in he can see 9 other fields(maybe less or more depending on the level)
my tables are set in this way:

  1. passwords(fields: passID, username, login, password,level(numerical))
    2.viewingtable(fields: field1 - to filed12)
    can it be done?
    I was trying to set user group permissions for the same table BUT

    it only allows me to choose TABLES, but not fields in the table in question.
    is it possible to solve that?

C
chris 12/11/2006

I have a table with 12 fields

I would like to accomplish this:
when user1 logs in he can only see 9 fields
when user2 logs in he can see 9 other fields(maybe less or more depending on the level)
my tables are set in this way:

  1. passwords(fields: passID, username, login, password,level(numerical))
    2.viewingtable(fields: field1 - to filed12)
    can it be done?
    I was trying to set user group permissions for the same table BUT

    it only allows me to choose TABLES, but not fields in the table in question.
    is it possible to solve that?



I don't believe you can set field level viewing or security in this asp generator, I don't know of any that would without some specific programing. That being said:

You could try using adding table views from the table list for that table and using the group level security to restrict the viewing of those fields in those new tables.

Just a thought.

Hope it helps,

Chris.