newbie
From: Bob Brewer <brewerb_at_vnet.ibm.com>
Date: 1996/11/08
Message-ID: <3283895E.20D0_at_vnet.ibm.com>#1/1
Date: 1996/11/08
Message-ID: <3283895E.20D0_at_vnet.ibm.com>#1/1
I'm new to sql & oracle. I need to add a user to an existing db. I've created the user & can login. But, I can't "select * from table" where table is an existing table. I have done "grant select to newuser". Didn't work. I have done "grant all to newuser". Didn't work. Now what.
Other questions.
- How can you get a list of tables in a particular db.
- How can a user look at their schema, views, etc.
- How can an admin look at what is already there when he takes over?
Help would be appreciated.
Thanks
Bob Brewer
brewerb_at_vnet.ibm.com
Received on Fri Nov 08 1996 - 00:00:00 CET