Home » RDBMS Server » Security » Grant privileges on table to user
Grant privileges on table to user [message #112205] Wed, 23 March 2005 12:52 Go to next message
bpham
Messages: 6
Registered: March 2005
Junior Member
Hi all,

I'm a beginner of oracle developer, I created a table as aim owner, and I grant privileges on table to public. When I logon as user the table does not exits, but if I logon as aim owner, the table is there.

I don't know why, can anyone here help me out with this, did I missing something here?

Thanks in advance.

bp
Re: Grant privileges on table to user [message #112212 is a reply to message #112205] Wed, 23 March 2005 13:52 Go to previous messageGo to next message
bpham
Messages: 6
Registered: March 2005
Junior Member
Follow up.

The table is in a different schema, how do I specifying the schema explicitly?

thanks,
bp
Re: Grant privileges on table to user [message #112233 is a reply to message #112205] Wed, 23 March 2005 16:53 Go to previous message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
schema_name.table_name

Really need to take some time to read the basic oracle documentation (it is free!) before asking others to take time to answer your questions.
Previous Topic: How to change password of Sysdba
Next Topic: GRANT sysdba fails with ORA-01996 (pawwword file full)
Goto Forum:
  


Current Time: Wed Dec 08 23:02:26 CST 2021