Expand my Community achievements bar.

SOLVED

delete a schema with nms as namespace

Avatar

Community Advisor

Hi all,

 

Do you know how I can delete a schema created with nms as namespace? 

Quick summary, one of my developer created a schema and used nms as namespace. so it's automatically considered it as an ootb schema and I'm not able to delete it both with my operator (with administration named right) and admin operator. 

Also tried to delete it from the back end using SQL as ACC is installed on premise but not able as database structure update was not completed.

I'm thinking to use internal user in next step but not sure if it will work.

DavidKangni_0-1595880828293.png

 

Any thoughts @Jonathon_wodnicki  @kapilKochar  @Milan_Vucetic  @Raj_Ganta  @Jyoti_Yadav  @_Manoj_Kumar_ ?

 

Thanks,

David



David Kangni
1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Hi,

 

That must be a new thing. Internal has same access as anyone in operator table with admin right.

Since you have admin right, just use a sql script?

delete from xtkentity where sname='Marketing offers';
drop table ...

 

Thanks,

-Jon

View solution in original post

2 Replies

Avatar

Correct answer by
Community Advisor

Hi,

 

That must be a new thing. Internal has same access as anyone in operator table with admin right.

Since you have admin right, just use a sql script?

delete from xtkentity where sname='Marketing offers';
drop table ...

 

Thanks,

-Jon

Avatar

Community Advisor

Hi Jon,

It works. They added this restriction in the latest release. drop table was not working as the database structure was not updated.

Thank you so much.

David



David Kangni