DBA_learner
Member
Hello all, hope you all are doing well!!!
This post is regarding Progress database access through SQL client. As per my knowledge, when we want to give access of a Progress database table to SQL user then we create one user (in _user) with sysprogress userid and grant access.
I have been reading multiple posts regarding this and am very confused with below mentioned quires of mine:-
1. When there is no user created in _USER table then there is one default “OS” user id (how to check this) with _user table. What is this default user id and password or what default user id and password do we need to use while accessing progress database trough SQL client.
2. Can we access all database tables via this userid? If yes, then what all permission we have for those DB tables? If it has all of the permissions (Read & Write) then what is the need of creating userid’s.
3. If we have multiple databases on a server then this “OS” userid will be same for all databases or it will be different?
4. If this “OS” user id has permission (read/write) of accessing all tables and we add few new tables into the database then this userid still has the same permission for newly added DB tables, If No then do we have to create new userid for newly added tables? (Because when we create new userid in _user table then default OS userid won’t be there for accessing previous tables)…
Kindly suggest.
Regards,
Learner…
This post is regarding Progress database access through SQL client. As per my knowledge, when we want to give access of a Progress database table to SQL user then we create one user (in _user) with sysprogress userid and grant access.
I have been reading multiple posts regarding this and am very confused with below mentioned quires of mine:-
1. When there is no user created in _USER table then there is one default “OS” user id (how to check this) with _user table. What is this default user id and password or what default user id and password do we need to use while accessing progress database trough SQL client.
2. Can we access all database tables via this userid? If yes, then what all permission we have for those DB tables? If it has all of the permissions (Read & Write) then what is the need of creating userid’s.
3. If we have multiple databases on a server then this “OS” userid will be same for all databases or it will be different?
4. If this “OS” user id has permission (read/write) of accessing all tables and we add few new tables into the database then this userid still has the same permission for newly added DB tables, If No then do we have to create new userid for newly added tables? (Because when we create new userid in _user table then default OS userid won’t be there for accessing previous tables)…
Kindly suggest.
Regards,
Learner…