How to add user not read not write (authority)

[yls999]

I want to add one user only read the progress db, not write the db.

Does anyone ever do so？ Thanks.

 

[karavati]

hi ,


which operating system u r using for progress db. when u r using linux OS , u can use chmod permissions for read, write to lock on every file.
I hope this solution wil be tad relevant to your question.

 

[sdjensen]

Create a write trigger and return error if user is not allowed to write to database.

 

[karavati]

how to create a write trigger? do not access database for write mode.

 

[karavati]

how to create write trigger , i dont hav knowledge on it.

please could u tel me.i think it may be did by developers

 

[TomBascom]

I want to add one user only read the progress db, not write the db.

Does anyone ever do so？ Thanks.

Assuming that you are concerned about a 4GL user you would do this through the data dictionary. Pick the Admin -> Security -> Edit Data Security Option. Then pick the tables that you want to prevent this user from writing and add the string ",!username" to the CAN-WRITE, CAN-CREATE and CAN-DELETE fields as appropriate.

 

[tamhas]

Remembering of course, that these permissions are noticed only at compile time.

 

[TomBascom]

Actually there are some options in OE10 that make them run-time too.

 

[tamhas]

Oh really ... they keep sneaking these things in. What options are those?

 

[TomBascom]

Dict -> Admin -> Database Options...

       ┌────────────Database Options (sports) ────────────┐
       │                                                  │
       │   Auditing Options:                              │
       │      [ ]Use Application User Id for Auditing     │
       │      [ ]Enforce Audit Insert Privilege           │
       │                                                  │
       │   Security Options:                              │
       │      [ ]Trust Application Domain Registry        │
       │      [ ]Record Authenticated Client Sessions     │
       │      [ ]Disallow Blank UserId                    │
       │      [X]Use Runtime Permissions Checking         │
       │                                                  │
       │                                                  │
       │                 <   OK    > < Cancel  >          │
        ──────────────────────────────────────────────────┘