All functions altering existing tables return error

[GordonBryden]

All functions that alter an existing table seem to be returning the following error:

Error in eval(call("force", as.symbol(paste0("..", x)))) :
argument "..2" is missing, with no default

This has been tested with the NB1 database, using write_dataframe_to_db and drop_table_from_db

I am able to write a new table to the ADM, and retrieve data from it, but I cannot append, overwrite or delete anything from the table.

[GordonBryden]

This seems to mostly be a problem when the table is versioned, so I think the error message is due to insufficient permissions. I can append to a versioned table, but not upload a new table.

[tomwilsonsco]

@GordonBryden Thanks for raising. That's correct the ADM team have changed the default group permissions, so you don't have permission to drop / overwrite versioned tables, you need to ask them.
This package should have an appropriate warning already in place but if not appearing in what you are doing I will need to look at why - please send what you are running.

[GordonBryden]

RtoSQLServer::drop_table_from_db(server,
database,
schema,
table_name = "ExampleUpload")

[tomwilsonsco]

@GordonBryden I'm not getting the same, i.e the expected warning that do not have permission is showing up when I attempt to drop a versioned table. If you can send me (probably by internal email) the connection details of the DB you're using, I can ask the ADM team to grant me permission and test the same. I assume you are using the latest version installed from the internal server for R 4.4.2 and DBI, odbc installed from the server too.