How to define a user role for reading only?

hazem
hazem Member Posts: 187
Hello,

I have a user for which i want to allow only reading information. How to define a role allowing only navigating and reading information?

Thanks

Comments

  • jsnayberk
    jsnayberk Member Posts: 58
    If you want this user to be able to read all Tables just define a new role, i.e. "ALLREADONLY" and give Read permission to Table 0 (all Tables). Assign that role to the user and additionally assign the predefined "ALL" role to that user in order to be able to run basic functionality.
    If you want this user to have read privileges for specific tables only you will have to specify each of this tables for that role.
    --
    Josef Snayberk
  • sudhakar_568
    sudhakar_568 Member Posts: 6
    If you want to assign role for reding only then you should follow the steps
    1.create role named as ex.readonly->roles->assign "ALL" role
    2.give objects name that you want to read and don't give other permissions such as modify,insert..
    3.if you want permission to all table define Table object as 0->click on ALL OBJECTS button and assign "ALL" role

    s.v.sudhakar