OraFAQ Forum: Security » rights of a user on a different schema dissapeare

Home » RDBMS Server » Security » rights of a user on a different schema dissapeare

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

rights of a user on a different schema dissapeare [message #196439]

Thu, 05 October 2006 06:17

dast
Messages: 4
Registered: June 2006

Junior Member

Hi,

We have a created a new user who has rights on a table in a different schema.

The table is everynight be dropped and new created, so the rights are gone every day of that users who had rights on that table.

Is there a method so the rights will be there when that table is dropped.

Thanx,

Dave

Report message to a moderator

Re: rights of a user on a different schema dissapeare [message #196442 is a reply to message #196439]

Thu, 05 October 2006 06:23

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, no.

But - why do you drop the table? See how many problems it brings? Why don't you, instead, TRUNCATE the table and insert new data into it?

How do you create the table? Through the script? If so, you could include required GRANT statements into it. If it is dynamically created, include GRANTs into another EXECUTE IMMEDIATE.

Report message to a moderator

Re: rights of a user on a different schema dissapeare [message #196444 is a reply to message #196442]

Thu, 05 October 2006 06:29

dast
Messages: 4
Registered: June 2006

Junior Member

The problem is that there is a application what does the drop table. i can't change it because it's in there softwarecode.

Thanx,

Dave

Report message to a moderator

Re: rights of a user on a different schema dissapeare [message #200362 is a reply to message #196444]

Mon, 30 October 2006 09:12

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Try this but i am not sure.

You create one trigger whenever particular table is created trigger fire and provide privs to users.

Report message to a moderator

Previous Topic:	UNABLE TO LOGIN
Next Topic:	How can the user SYS or SYSTEM to find out a user's password (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 10:16:50 CDT 2025