Home » SQL & PL/SQL » SQL & PL/SQL » Need your immediate reply.
Need your immediate reply. [message #2567] Sun, 28 July 2002 05:43 Go to next message
meena
Messages: 36
Registered: December 2000
Member
What is the tree structure of oracle?
what is roll?

Report message to a moderator

Re: Need your immediate reply. [message #2570 is a reply to message #2567] Sun, 28 July 2002 21:58 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Qué? Tree structure? Can you explain that a little further.

A role (not roll) is a group of privileges (grants). If you create e.g. a role 'USER_ROLE' and you grant several privileges to this role, you can grant this role to different users, who all will have the same rights on the DB. If you change the role, all users that have this role will immediately have the new adapted rights. The only drawback is that roles don't work through PL/SQL units (at least when you use creators rights, but that's another story).

For maintenance, roles come in handy.

MHE

Report message to a moderator

Re: MEaning of roll [message #2577 is a reply to message #2567] Mon, 29 July 2002 05:18 Go to previous message
paritosh agrawal
Messages: 8
Registered: May 2002
Junior Member
Dear Meena ji,
This is role not roll.It seems u have not much knowledge of ORACLE.do purchase Oracle Developer 2000 by Ivan Bayross.Its very short book but it will make all ur fundas totally fundoo.
Thanks.

Report message to a moderator

Previous Topic: ORACLE Instance Terminate
Next Topic: What command to see all triggers?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 22:57:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.