OraFAQ Forum: Client Tools » unable to drop roles

Home » Other » Client Tools » unable to drop roles (oracle 11.2.0.2, AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

unable to drop roles [message #538986]

Tue, 10 January 2012 12:09

lg123
Messages: 225
Registered: August 2008

Senior Member

When I try to drop the roles in dbartisan tool, I get an error saying "Drop DDL for **_***********_ROLE has not been generated because it is a system object", but if i go to sql prompt and say "drop role rolename", it is working. How do I remove the role in dbartisan itself? Please advise.

Report message to a moderator

Re: unable to drop roles [message #538987 is a reply to message #538986]

Tue, 10 January 2012 12:20

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>How do I remove the role in dbartisan itself?

What happens if you login again using dbartisan after issuing DDL from sqlplus?

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: unable to drop roles [message #538989 is a reply to message #538987]

Tue, 10 January 2012 12:39

lg123
Messages: 225
Registered: August 2008

Senior Member

Once I remove the role from sql prompt, I dont see that role in dbartisan. But I could not remove the role from dbartisan.

Report message to a moderator

Re: unable to drop roles [message #538990 is a reply to message #538989]

Tue, 10 January 2012 12:43

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Once I remove the role from sql prompt, I dont see that role in dbartisan
dbartisan provided you a Read Consistent view of the DB as of the time it started.
If it is important to you to see a current snapshot, then you need to start new session.

Report message to a moderator

Re: unable to drop roles [message #538993 is a reply to message #538990]

Tue, 10 January 2012 12:56

lg123
Messages: 225
Registered: August 2008

Senior Member

In dbartisan how to successfully remove the roles in a database?

Report message to a moderator

Re: unable to drop roles [message #538994 is a reply to message #538993]

Tue, 10 January 2012 13:07

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>In dbartisan how to successfully remove the roles in a database?

post this question in dbartisan forum

Report message to a moderator

Re: unable to drop roles [message #538995 is a reply to message #538994]

Tue, 10 January 2012 13:09

lg123
Messages: 225
Registered: August 2008

Senior Member

"Client Tools" portion of this forum can have discussions on dbartisan as well right?

Report message to a moderator

Re: unable to drop roles [message #538996 is a reply to message #538995]

Tue, 10 January 2012 13:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>"Client Tools" portion of this forum can have discussions on dbartisan as well right?

but what if nobody here uses or knows about dbartisan?
I do not recall it ever being discussed here.
I did not mean posting here was wrong, but you might get answer faster some place else.

Report message to a moderator