XOS: Can XOS Secure SQL Tables So that Non-owners Can Execute ALTERs or DROPs?

XOS: Can XOS Secure SQL Tables So that Non-owners Can Execute ALTERs or DROPs?

The answer is no.     Regardless of the access rights assigned in the XOS rule to the user attempting the SQLCI ALTER,  the user doing the SQLCI ALTER must be the table owner, the group manager or SUPER.SUPER to be successful.  The id attempting the ALTER must also have read and write access to the affected catalogs.




If you are unable to locate the solution needed or if you need additional assistance please Click Here to open a case from our Customer Care Portal.

    • Related Articles

    • XMA: Database Tables are filling up

      You may either partition the tables or create new, larger tables. Option 1 - Partition the AUDSESS and AUDDET tables Partitioning the AUDSESS and AUDDET files will give them more room to grow. To assist in this process there is a file in the XYGATEMA ...

    • XSW: Enabling SQL Remote Connections

      Enable remote connections on the instance of SQL Server that you want to connect to from a remote computer. 1. Open MS/SQL Management Studio and right-click server name in the left pane and select Properties 2. Select Connections in the left pane and ...

    • XOS: How to uninstall the XOS SEEP for Guardian and OSS

      Guardian: XOS_SAFECOM_UNINSTALL The XOS_SAFECOM_UNINSTALL macro removes the program from the SAFECOM configuration by doing a DELETE EVENT-EXIT-PROCESS XOS. OSS: XOS_OSSSEEP_DISABLE The XOS_OSSSEEP_DISABLE macro alters SCF so that the XOS ...

    • Moving OSCONF and OSACL files from an existing XOS environment to a new XOS environment

      1. Rename the OSCONF file in the new XYGATEOS installation location to OSCONFN 2. FUP DUP the OSCONF from the old installation to the new XYGATEOS installation location. Make sure that the file security and ownership matches that of the original ...

    • XOS: NORECORD IGNORED causing frequent audit rollover

      If you want to get rid of ?IGNORED?s, set the AUDIT-NORECORD keyword to OFF in the OSCONF. Additionally, depending on whether or not you want NORECORD audits for non-IGNORE entries, just setting AUDIT_NORECORD OFF wouldn't work. You would also need a ...