So we have four SQL Remote Users that we are attempting to revoke from the list of SQL Remote Users on our production database.
I would remove the users outright, but they will still be logging into the database internally in the office.
When I attempt to revoke each remote, I get the warning about subscriptions. I say I'm sure. Revoke the user's remote status.
Immediately I receive an error saying - The user user_name could not be modified in the database. Cannot revoke the permissions while user user_name is actively replicating transactions.
SQLCODE: -1080 SQLSTATE: 40001 SQL Statement: REVOKE REMOTE FROM user_name
I went into each users subscriptions and turned them off. And then removed them. I also did a remote reset on each user.
When I attempted to revoke the remote again, I still received the same error.
Am I missing something additional that needs to be deleted or changed in order to revoke these users from the SQL Remote Users list?
Any thoughts would be greatly appreciated!!
SQL Anywhere 22.214.171.12442
asked 23 Sep '16, 15:43