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.
