Hello Group;
I would like to REVOKE all permissions on some tables that the ODBC user 'sysprogress' has been given access to when it was setup.
I am using the ODBC Kit .bat file to connect to the database with the "sqlexp" command.
I have entered the command:
REVOKE SELECT ON PUB.table FROM sysprogress ;
And I have also used the COMMIT; after the command.
I can still select data from 'PUB.table' via ODBC.
Do I need to stop and restart the database at this point?
I want to modify this user, because all clients have this ODBC setup already and I don't want to have to reconfigure them. Ideally, they should have set up a different user with specific security setup initially.
Any help is appreciated.
Regards,
George Hicks
PCI
I would like to REVOKE all permissions on some tables that the ODBC user 'sysprogress' has been given access to when it was setup.
I am using the ODBC Kit .bat file to connect to the database with the "sqlexp" command.
I have entered the command:
REVOKE SELECT ON PUB.table FROM sysprogress ;
And I have also used the COMMIT; after the command.
I can still select data from 'PUB.table' via ODBC.
Do I need to stop and restart the database at this point?
I want to modify this user, because all clients have this ODBC setup already and I don't want to have to reconfigure them. Ideally, they should have set up a different user with specific security setup initially.
Any help is appreciated.
Regards,
George Hicks
PCI