unable to delete csm custom tables , restricting business rule unable to deactivate

[#1]

Hi All,

I was trying to delete csm custom tables getting below error and i unable to active false that BR. kindly suggesst

var gr = new GlideRecord('sys_db_object');
gr.addQuery('sys_id','0a9b23c5db48ec90765427360596196d');
gr.query();

if(gr.next()) {

gr.deleteRecord();
}

Validate Table Delete - BR

Operation against file 'sys_db_object' was aborted by Business Rule 'Validate Table Delete^0a9b23c5db48ec90765427360596196d'. Business Rule Stack:Validate Table Delete
Background message, type:error, message: Insufficient rights to delete table sn_customerservice_stakeholders. User does not have delete access.

 kindly help me to delete this

[Willem]

The account you are logged in with while running the Script does not have sufficient rights.

Try with an admin account or see if there is a Delete ACL that is preventing you from Delete access.

[Ankur Bawiskar]

Hi,

Can you explain what is the business need to delete table from script?

ACLs won't be evaluated when you use GlideRecord.

So please check that business rule which might be restricting -> Validate Table Delete

You cannot delete tables which comes with Store applications.

This table "sn_customerservice_stakeholders" seems OOB table from CSM scope so you possibly cannot delete it.

If you still want to try then do this

var gr = new GlideRecord('sys_db_object');
gr.addQuery('sys_id','0a9b23c5db48ec90765427360596196d');
gr.query();

if(gr.next()) {

gr.setWorkflow(false); // to avoid triggering any BR

gr.deleteRecord();
}

Regards
Ankur

[#4]

Its custom table , one of my colleague created by mistake and want to delete .

[Willem]

To delete a table OOTB you need to be Admin. Do you have the admin role?

Also have you tried using the User Interface? Navigate to:

• System Definitions --> Tables
• Search for your table
• Delete