Re: another role question

In <27tidd$hen_at_elroy.jpl.nasa.gov> jason_at_woody.uucp (Jason Yi) writes:

>Hi,
 

>As I've been experimenting with roles, I'm getting more confused.
 

>In below example,
 

>MYTABLE
>-------
>COLUMN1 NUMBER <== primary key
>COLUMN2 NUMBER
>COLUMN3 NUMBER
>COLUMN4 NUMBER
 
>CREATE ROLE SW;
 
>GRANT SELECT ON SYSTEM.MYTABLE TO SW;
>GRANT DELETE, INSERT, UPDATE
> (COLUMN2, COLUMN3, COLUMN4)
>ON SYSTEM.MYTABLE
>TO SW;
 

>GRANT SW TO OPS$MYSELF;

>Does above grant statement allows me to select, delete, insert, and update
>to individual columns except COLUMN1?

Assuming that "me" is OPS$MYSELF rather than the "me" who executed the grants then, yes. (The privileges of the "me" who executed the grants are of course unchanged.)

                                        If not, what does above grants mean

If OPS$MYSELF is still unable to access MYTABLE, then maybe (s)he does not have the SW role enabled.

graeme

--
Disclaimer:	The author's opinions are his own, and not necessarily
		those of Pyramid Technology Ltd. or Pyramid Technology Inc.
---------------------------------------------------------------------------
      -m------- Graeme Sargent                 Voice: +44 (0)252 373035
    ---mmm----- Senior Database Consultant     Fax  : +44 (0)252 373135
  -----mmmmm--- Pyramid Technology Ltd.        Telex: Tell who???
-------mmmmmmm- Farnborough, Hants  GU14 7PL   Email: graeme_at_pyra.co.uk
---------------------------------------------------------------------------
    We have the technology.  The tricky bit is learning how to use it.