Oracle Database Discussions

Hi All,

For our DB Build process, i have to give SYS user details for creating user and granting permissions to that user. Instead of using SYS user, i have created one user called 'grantest' and allow it for creating user and granting permissions to that user. But i am encountering errors while giving sys user packages to the user through grantest.

Conn sys/xxx as sysdba

create user grantest identified by grantest ;

grant create session,grant any privilege,grant any role, CREATE USER,DROP USER,grant any object privilege to grantest;

conn grantest/grantest

create user devtest identified by devtest;

grant connect,resource to devtest;

grant execute on sys.dbms_lock to devtest;
grant execute on sys.dbms_lock to devtest
*
ERROR at line 1:
ORA-01031: insufficient privileges

Is ther any alternative ways to achieve my requirement.

Thanks,

Moorthy.GS