Home » Other » General » Granting rights to user
Granting rights to user [message #103708] Tue, 24 February 2004 11:25 Go to next message
Shah
Messages: 36
Registered: June 2002
Member
Hi,

 I have a Oracle 8i database. I have created a schema under a userame user1. I would like to have user2 rights to select from any table from user1's schema. How do I do that? I have given user2 rigths to select any table on the database but that does not allow user2 to access user1 database. User2 needs to log in from an application so doing a select from user1.schema is not an option. I need to give rights to user2 to user1's tables.

Thanks

Shah

Report message to a moderator

Re: Granting rights to user [message #103716 is a reply to message #103708] Wed, 25 February 2004 06:07 Go to previous message
JAC
Messages: 12
Registered: February 2003
Junior Member
Create a Public synonym for the objects and grant that to public/specific user.
HTH

Report message to a moderator

Previous Topic: Re: Coolgen
Next Topic: Should 9iJDeveloper and related tools OR 9i Forms and Reports ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 30 03:47:31 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.