Search results for query: *

hi mufasa, thanks. you were right, running these two queries returned different results. On my existing database, it returned: SQL> select owner, table_name, privilege from user_tab_privs order by 1,2,3 OWNER TABLE_NAME ------------------------------...

hmm... to Robbie: the app i am using to connect will hang for the new database (in the trace, hangs on execution of the query i posted earlier). to Mufasa: I'm not too sure what I have to do here. I ran 'describe user_tab_privs' and see this: Name Null...

Hi Mufasa, thank you for that. So indeed, the roles are the same. the queries are the same, I do not understand why the existing database works, but the new one will not. The only difference I guess as mentioned before is the slightly newer version in the new database.. Any ideas? I am...

hmm.. okay running what you suggested Mufasa, I get no bind variables have been defined. But in my app, I know the bind variables have been set. Running this: SELECT NULL, OWNER, OBJECT_NAME, CASE WHEN OWNER IN...

Hi Robbie, I can probably get this SQL modified, but not immediately and rather get it working with the existing query since it should be working. So how did you test if the query I gave out worked for you? Because when I run this query through SQL Plus, it tells me "SP2-0552: Bind variable...

Hi, yes, in fact I have been trying to see the tables that the user (the one who created it in the first place). I ran a trace of what query was being sent, apparently this is the query which I'm having a bit of trouble breaking down. SELECT NULL, OWNER, OBJECT_NAME, CASE WHEN OWNER IN...

Hi, thanks for the help. After granting resources to my user, I was able to create tables just fine. But I am still unable to see these tables for some reason. I see that the tables are there from going onto the enterprise manager. so if this user was the one who created this table, having...

Hi, I am trying to create a new oracle databsae, but cannot seem to create a user with the correct privileges. I am having trouble creating a user with less than admin privilegs but want them to be able to create any table, select any table, but only within this schema. I was trying to...