Home » RDBMS Server » Server Administration » Granting Privileges........
Granting Privileges........ [message #246800] Fri, 22 June 2007 01:01 Go to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
Hi All,

My Query is:
Suppose i just created two schema A & B.
I want to give create table privilege to user A specificaly on user B not on all the other users.
How it is possible?......


Regards,
Dinesh
Re: Granting Privileges........ [message #246801 is a reply to message #246800] Fri, 22 June 2007 01:04 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>How it is possible?......
The person who decreed such a requirement should be summarily fired.
Re: Granting Privileges........ [message #246806 is a reply to message #246801] Fri, 22 June 2007 01:14 Go to previous messageGo to next message
lokhande.dinesh29
Messages: 36
Registered: May 2007
Member
Buddy for ur kind information it is possible in teradata
Re: Granting Privileges........ [message #246825 is a reply to message #246806] Fri, 22 June 2007 01:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
So use Teradata.

Regards
Michel
Re: Granting Privileges........ [message #246837 is a reply to message #246801] Fri, 22 June 2007 03:10 Go to previous message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
anacedent wrote on Fri, 22 June 2007 07:04
>How it is possible?......
The person who decreed such a requirement should be summarily fired.

Why? So you would have someone fired because he asked for something on a system that they didn't fully understand but had seen the same capability on another system e.g. what about a new member of staff that (mistakenly) thought that this would be the best way. Would you fire them, or possibly try to educate them as to the way to do it in Oracle?
Previous Topic: Private SQL Area
Next Topic: ASM Disk in Ignored state
Goto Forum:
  


Current Time: Sat Nov 30 06:47:34 CST 2024