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.