statement terminator and grants...

[nekelly]

Hello All,

could some kind soul tell me the difference between terminating statements with / and ; in a SQL script?
Is there a difference?

While I'm at it, would anyone know why a user with DBA proviliges (e.g. system) can't grant object priviliges on objects in another schema? e.g.

SQL> connect system/manager
Connected.

SQL> grant select on noel.test to bob;
grant select on noel.test to bob
*
ERROR at line 1:
ORA-01031: insufficient privileges


SQL> connect noel/noel
Connected.
SQL> grant select on noel.test to bob;

Grant succeeded.

SQL>

I thought someone with DBA privs could grant privs on any object?

Thanks,
Noel.

[Shestakov]

1)
/ can terminate any sql, pl/sql script, including single sql statments.
; can terminate only single sql statments.

2)
To grant an object privilege, you must fulfill one of the following conditions:
* You own the object specified.
* You have been granted the object privileges being granted with the GRANT
OPTION.
(but some object privileges can't grant to role with grant options, only directly to user)
DBA role has system privilege GRANT ANY PRIVILEGE WITH GRANT OPTIONS,
but this privilege doesn't work with user's object privileges.




[Edited by Shestakov on 04-24-2002 at 01:41 PM]