MAGIC: cursor.execute("DROP SEQUENCE AUTH_USER_SEQUENCE") cursor.execute("DROP SEQUENCE AUTH_GROUP_SEQUENCE") cursor.execute("DROP SEQUENCE AUTH_MEMBERSHIP_SEQUENCE") cursor.execute("DROP SEQUENCE AUTH_PERMISSION_SEQUENCE") cursor.execute("DROP SEQUENCE AUTH_EVENT_SEQUENCE") cursor.execute("DROP SEQUENCE AUTH_CAS_SEQUENCE")
and now I have: Welcome to web2py! How did you get here? -My answer: --Gray Hairs and not giving up and asking for help until I figured this stuff out!!!!!! Thank-you Everyone!!!!! Next life lesson. Understanding Linux Permissions and global variables. Ill post my install script after I test on a totally blank non-prod provisioned server in my env. On Monday, December 28, 2015 at 10:11:53 AM UTC-8, Michael Messmer wrote: > > Alright it worked for blah: > > cursor.execute("DROP SEQUENCE BLAH_SEQUENCE") > > Going for the rest now. > > On Monday, December 28, 2015 at 10:09:31 AM UTC-8, Michael Messmer wrote: >> >> Ahh, I am ULTRA-Newb to db's: >> >> here is what it returned: >> >> >>> for row in cursor: >> ... print row >> ... >> ('SYS_C0012098', 'INDEX') >> ('SYS_LOB0000092306C00003$$', 'LOB') >> ('AUTH_CAS_SEQUENCE', 'SEQUENCE') >> ('AUTH_EVENT_SEQUENCE', 'SEQUENCE') >> ('AUTH_GROUP_SEQUENCE', 'SEQUENCE') >> ('AUTH_MEMBERSHIP_SEQUENCE', 'SEQUENCE') >> ('AUTH_PERMISSION_SEQUENCE', 'SEQUENCE') >> ('AUTH_USER_SEQUENCE', 'SEQUENCE') >> ('BLAH_SEQUENCE', 'SEQUENCE') >> ('AUTH_USER', 'TABLE') >> >> >> I just googled dropping Objects. Wish me luck. ill report back. >> >> >> On Monday, December 28, 2015 at 9:59:18 AM UTC-8, Dan Feeney wrote: >>> >>> You can view tables owned by the current user with: >>> >>> SELECT TABLE_NAME FROM USER_TABLES ORDER BY TABLE_NAME; >>> >>> >>> >>> You can view all objects owned by the current user with: >>> >>> SELECT OBJECT_NAME, OBJECT_TYPE FROM USER_OBJECTS ORDER BY 2, 1; >>> >>> >>> >>> HTH, >>> -Dan >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.