+ Reply to Thread
Page 1 of 4 1 2 3 ... LastLast
Results 1 to 10 of 36

PL/SQL privileges

  1. PL/SQL privileges

    Hi,

    A user has "create any table" privileges and the same user has a procedure
    with

    "execute immedate 'create table ...'"

    when the user tries to run the procedure, it returns the following error

    "ORA-01031: insufficient privileges"

    thanks



  2. Re: PL/SQL privileges

    In article , Jon says...
    > Hi,
    >
    > A user has "create any table" privileges and the same user has a procedure
    > with
    >
    > "execute immedate 'create table ...'"
    >
    > when the user tries to run the procedure, it returns the following error
    >
    > "ORA-01031: insufficient privileges"
    >


    You'll probably find that the procedure is effectively trying to create
    the table under the user that 'owns' the procedure, rather than that
    which is executing it.

    --

    jeremy

  3. Re: PL/SQL privileges

    In article , Jon says...
    > Hi,
    >
    > A user has "create any table" privileges and the same user has a procedure
    > with
    >
    > "execute immedate 'create table ...'"
    >
    > when the user tries to run the procedure, it returns the following error
    >
    > "ORA-01031: insufficient privileges"
    >


    You'll probably find that the procedure is effectively trying to create
    the table under the user that 'owns' the procedure, rather than that
    which is executing it.

    --

    jeremy

  4. Re: PL/SQL privileges

    In article , Jon says...
    > Hi,
    >
    > A user has "create any table" privileges and the same user has a procedure
    > with
    >
    > "execute immedate 'create table ...'"
    >
    > when the user tries to run the procedure, it returns the following error
    >
    > "ORA-01031: insufficient privileges"
    >


    You'll probably find that the procedure is effectively trying to create
    the table under the user that 'owns' the procedure, rather than that
    which is executing it.

    --

    jeremy

  5. Re: PL/SQL privileges

    In article , Jon says...
    > Hi,
    >
    > A user has "create any table" privileges and the same user has a procedure
    > with
    >
    > "execute immedate 'create table ...'"
    >
    > when the user tries to run the procedure, it returns the following error
    >
    > "ORA-01031: insufficient privileges"
    >


    You'll probably find that the procedure is effectively trying to create
    the table under the user that 'owns' the procedure, rather than that
    which is executing it.

    --

    jeremy

  6. Re: PL/SQL privileges

    In article , Jon says...
    > Hi,
    >
    > A user has "create any table" privileges and the same user has a procedure
    > with
    >
    > "execute immedate 'create table ...'"
    >
    > when the user tries to run the procedure, it returns the following error
    >
    > "ORA-01031: insufficient privileges"
    >


    You'll probably find that the procedure is effectively trying to create
    the table under the user that 'owns' the procedure, rather than that
    which is executing it.

    --

    jeremy

  7. Re: PL/SQL privileges

    In article , Jon says...
    > Hi,
    >
    > A user has "create any table" privileges and the same user has a procedure
    > with
    >
    > "execute immedate 'create table ...'"
    >
    > when the user tries to run the procedure, it returns the following error
    >
    > "ORA-01031: insufficient privileges"
    >


    You'll probably find that the procedure is effectively trying to create
    the table under the user that 'owns' the procedure, rather than that
    which is executing it.

    --

    jeremy

  8. Re: PL/SQL privileges

    In article , Jon says...
    > Hi,
    >
    > A user has "create any table" privileges and the same user has a procedure
    > with
    >
    > "execute immedate 'create table ...'"
    >
    > when the user tries to run the procedure, it returns the following error
    >
    > "ORA-01031: insufficient privileges"
    >


    You'll probably find that the procedure is effectively trying to create
    the table under the user that 'owns' the procedure, rather than that
    which is executing it.

    --

    jeremy

  9. Re: PL/SQL privileges


    Check this for relevance

    http://www.jlcomp.demon.co.uk/faq/plsql_privs.html

    --
    Regards

    Jonathan Lewis

    http://www.jlcomp.demon.co.uk

    http://www.jlcomp.demon.co.uk/faq/ind_faq.html
    The Co-operative Oracle Users' FAQ

    http://www.jlcomp.demon.co.uk/seminar.html
    Optimising Oracle Seminar - schedule updated May 1st


    "Jon" wrote in message news:c8hvrf$6mc$1@unbe.sarenet.es...
    > Hi,
    >
    > A user has "create any table" privileges and the same user has a procedure
    > with
    >
    > "execute immedate 'create table ...'"
    >
    > when the user tries to run the procedure, it returns the following error
    >
    > "ORA-01031: insufficient privileges"
    >
    > thanks
    >
    >




  10. Re: PL/SQL privileges


    Check this for relevance

    http://www.jlcomp.demon.co.uk/faq/plsql_privs.html

    --
    Regards

    Jonathan Lewis

    http://www.jlcomp.demon.co.uk

    http://www.jlcomp.demon.co.uk/faq/ind_faq.html
    The Co-operative Oracle Users' FAQ

    http://www.jlcomp.demon.co.uk/seminar.html
    Optimising Oracle Seminar - schedule updated May 1st


    "Jon" wrote in message news:c8hvrf$6mc$1@unbe.sarenet.es...
    > Hi,
    >
    > A user has "create any table" privileges and the same user has a procedure
    > with
    >
    > "execute immedate 'create table ...'"
    >
    > when the user tries to run the procedure, it returns the following error
    >
    > "ORA-01031: insufficient privileges"
    >
    > thanks
    >
    >




+ Reply to Thread
Page 1 of 4 1 2 3 ... LastLast