OraFAQ Forum: Security » Grant privileges on table to user

Home » RDBMS Server » Security » Grant privileges on table to user

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Grant privileges on table to user [message #112205]

Wed, 23 March 2005 12:52

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

Report message to a moderator

Re: Grant privileges on table to user [message #112212 is a reply to message #112205]

Wed, 23 March 2005 13:52

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

Report message to a moderator

Re: Grant privileges on table to user [message #112233 is a reply to message #112205]

Wed, 23 March 2005 16:53

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.

Report message to a moderator

Previous Topic:	How to change password of Sysdba
Next Topic:	GRANT sysdba fails with ORA-01996 (pawwword file full)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 17:41:32 CDT 2024