On Tue, 24 Jun 2003 18:58:16 GMT, Hans Forbrich
<forbrich (AT) telusplanet (DOT) net> wrote:

I have to say this again and again. I have read the full manual
serveral times already. I only post questions that I could not solve
by running my own tests and rereading the manual.

Thanks

Peter wrote:

The manual explicitly states that granting a role is a system priv. (in table 17-1, right where I pointed you).

And yet you don't understand .....

The manual gives an explicit example of the operation in question. (in the examples in the SQL Reference in the
Grant command). With an explanation of how it works and what the implications are.

And yet you don't understand ......

As I said. I give up.

On Tue, 24 Jun 2003 19:56:05 GMT, Hans Forbrich
<forbrich (AT) telusplanet (DOT) net> wrote:

After your first reply and others' helpful replies, I got the idea
already. I don't know why you still think I do not understand.

Thanks

Sybrand Bakker <gooiditweg (AT) sybrandb (DOT) demon.nl> wrote


I second that.

Regards
/Rauf Sarwar

Morning Brian,

You wrote :


No disrespect to Peter who is trying to learn - I hope - but, having
been a Developer and a Techie for the last 18 odd years and having
worked in Local Government and commercial 'institutions', I have to say
you are on a losing wicket there !

I have *never* met as many people who don't want to try anything out for
themselves. If I had a £1.00 for every telephone call or email which
started of 'do you know if I can do ......' then I'd be very very very
rich inded.

I gave up answering 'have you tried to do ..... ?' as the answer was
always 'No, I though you would know.'.


Example for Senior Analyst trying to edit a file on an ICL VME mainframe
:

Her: "What does Error 50144 Required object does not exist mean" ?
Me: "What were you trying to do ?"
Her: "Edit a file"
Me: "Did it work ?"
Her: "No I got that error message"
Me: "What do you think it means ?"
Her: "I thought you would know"


And so on. Still the same today - get some other poor mug to do your
thinking for you.

I eventually started asnwering all questions with 'Yes, you can do
that'. Seems to have worked fine !


Cheers,
Norman.

-------------------------------------
Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar (AT) LFS (DOT) co.uk
Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

I know its an uphill battle, but once in a while, I still feel compelled
to take up the charge. While I know many, many people that you describe,
I also know those who look for answers themselves and test things out.
Guess which class of people are making the most money and have advanced
farther in their careers? I'm just trying to tell people who have at
least RTFM the next step they need to take.

Cheers,
Brian

Norman Dunbar wrote:
--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

Norman,

I'm also looking for that DBA job which lets me perform my tasks while
sitting on a beach on a tropical island, my notebook connected to the
Internet via wireless, and some island girl bringing me all sorts of
concoctions in glasses with little paper umbrellas. At then end of the
evening, I wow the locals with my ability fine tune my SGA while
simultaneously dancing under a moonlit sky with the king's daughter.

But that's just the world I find myself living in once in a while......

Sigh.
Brian

Norman Dunbar wrote:
--
================================================== =================

Brian Peasland
oracle_dba (AT) remove_spam (DOT) peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

Brian,

I think I saw that one on www.jobserve.co.uk this very morning. I was
thinking of applying but they needed 12 years RAC experience - which I
don't have.

Cheers,
Norman.

--
-----------------------------------------------------------------
Norman Dunbar (at home on Linux)
Oracle (AT) mssqlBountifulSolutions (DOT) co.uk

(Delete a Microsoft database name to reply - clue, mssql !)
-----------------------------------------------------------------


-----Original Message-----
From: news (AT) igsrsparc2 (DOT) er.usgs.gov (Janet Walz (GD) x6739)
[mailto:news (AT) igsrsparc2 (DOT) er.usgs.gov]On Behalf Of Brian Peasland
Posted At: Wednesday, June 25, 2003 5:10 PM
Posted To: server
Conversation: Creator of a role gets what rights?
Subject: Re: Creator of a role gets what rights?


Norman,

I'm also looking for that DBA job which lets me perform my tasks while
sitting on a beach on a tropical island, my notebook connected to the
Internet via wireless, and some island girl bringing me all sorts of
concoctions in glasses with little paper umbrellas. At then end of the
evening, I wow the locals with my ability fine tune my SGA while
simultaneously dancing under a moonlit sky with the king's daughter.

But that's just the world I find myself living in once in a while......