-
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|