HI Team,
We have Progress Database which is running on 9.1e version.
Today we have received incident where user dont have access to vo_mstr table while they are connecting from SQL explorer tool they facing "Access Denied error".
We checked using below command they dont have access to table and we have provided grant access to vo_mstr;
But before giving access we run select command and they have access table it worked fine but when we ran this command select * from sysprogress.systabauth where TBL='<vo_mstr>'; it showing as they dont have access.
SQLExplorer>select * from sysprogress.systabauth where TBL='<vo_mstr>';
GRANTOR GRANTEE TBLOWNER TBL INS DEL UPD SEL EXE NDX ALT REF
-------------------------------- -------------------------------- -------------------------------- -------------------------------- --- --- --- --- --- --- --- ---
When we checked in Progress Editor table has full access permissions for all users.
I'm confused where user informed they have already access on this table weekly once 1 job is scheduled.
Due to below full access to table are their jobs are working fine?
But why they are not able to connect from SQL explorer when they have select command is working?
How to check user has proper permissions on table from SQL explorer tool ?
lqqqqqqqqqqqqqqqqqqqqqqqqqq Table Name: "vo_mstr" qqqqqqqqqqqqqqqqqqqqqqqqqqqk
x Can-Read: * x
x Can-Write: * x
x Can-Create: * x
x Can-Delete: * x
x Can-Dump: * x
x Can-Load: * x
x x
x Examples: x
x * - All users (login Ids) are allowed access. x
x <user>,<user>,etc. - Only these users have access. x
x !<user>,!<user>,* - All except these users have access. x
x acct* - Only users that begin with "acct" allowed. x
x Do not use spaces in the string (they will be taken literally).
$DLC/bin/sqlexp -db slc -S tslc -H p5lp4 -user biuser -password
PROGRESS Version 9.1E as of Tue Oct 12 17:19:22 EDT 2004
SQLExplorer>select count(*) from pub.vo_mstr;
count(*)
-----------
425994
SQLExplorer>select * from pub.vo_mstr;
0000001 P010 8201 1766.6100000000 1998-12-18 1998-12-18 0 1999-01-07 0.0000000000 0.0000000000 0.0000000000 0.0000000000 0 USD 1.0000000000 0 3600 0.0000000000 0.0000000000 0 0;0;0 1 y550ekn 1 0.00000
SQLExplorer>select * from sysprogress.sysdbauth;
GRANTEE DBA_ACC RES_ACC
-------------------------------- ------- -------
BIUSER y
PGRESDBA y y
SYSPROGRESS y y
We have Progress Database which is running on 9.1e version.
Today we have received incident where user dont have access to vo_mstr table while they are connecting from SQL explorer tool they facing "Access Denied error".
We checked using below command they dont have access to table and we have provided grant access to vo_mstr;
But before giving access we run select command and they have access table it worked fine but when we ran this command select * from sysprogress.systabauth where TBL='<vo_mstr>'; it showing as they dont have access.
SQLExplorer>select * from sysprogress.systabauth where TBL='<vo_mstr>';
GRANTOR GRANTEE TBLOWNER TBL INS DEL UPD SEL EXE NDX ALT REF
-------------------------------- -------------------------------- -------------------------------- -------------------------------- --- --- --- --- --- --- --- ---
When we checked in Progress Editor table has full access permissions for all users.
I'm confused where user informed they have already access on this table weekly once 1 job is scheduled.
Due to below full access to table are their jobs are working fine?
But why they are not able to connect from SQL explorer when they have select command is working?
How to check user has proper permissions on table from SQL explorer tool ?
lqqqqqqqqqqqqqqqqqqqqqqqqqq Table Name: "vo_mstr" qqqqqqqqqqqqqqqqqqqqqqqqqqqk
x Can-Read: * x
x Can-Write: * x
x Can-Create: * x
x Can-Delete: * x
x Can-Dump: * x
x Can-Load: * x
x x
x Examples: x
x * - All users (login Ids) are allowed access. x
x <user>,<user>,etc. - Only these users have access. x
x !<user>,!<user>,* - All except these users have access. x
x acct* - Only users that begin with "acct" allowed. x
x Do not use spaces in the string (they will be taken literally).
$DLC/bin/sqlexp -db slc -S tslc -H p5lp4 -user biuser -password
PROGRESS Version 9.1E as of Tue Oct 12 17:19:22 EDT 2004
SQLExplorer>select count(*) from pub.vo_mstr;
count(*)
-----------
425994
SQLExplorer>select * from pub.vo_mstr;
0000001 P010 8201 1766.6100000000 1998-12-18 1998-12-18 0 1999-01-07 0.0000000000 0.0000000000 0.0000000000 0.0000000000 0 USD 1.0000000000 0 3600 0.0000000000 0.0000000000 0 0;0;0 1 y550ekn 1 0.00000
SQLExplorer>select * from sysprogress.sysdbauth;
GRANTEE DBA_ACC RES_ACC
-------------------------------- ------- -------
BIUSER y
PGRESDBA y y
SYSPROGRESS y y