locked
Default user schema functions RRS feed

  • Question

  • I have a database schema with DCP and managed to read all the tables under this schema by changing the default schema to users like this

    USE dbname;
    ALTER USER user1 WITH DEFAULT_SCHEMA = DCP;
    GO

    But I have some functions with DCP prefixed like DCP.dbfunc and by executing
    select dbfunc
    is giving error and
    select dcp.dbfunc
    is not giving any error.
     
    Wednesday, May 20, 2009 9:12 PM

Answers

  • For user defined function you need to mention two part name. ie owner.functionname


    Madhu
    MCITP, MCTS, MCDBA,MCP-- Blog : http://experiencing-sql-server-2008.blogspot.com/
    Thursday, May 21, 2009 12:54 AM

All replies

  • For user defined function you need to mention two part name. ie owner.functionname


    Madhu
    MCITP, MCTS, MCDBA,MCP-- Blog : http://experiencing-sql-server-2008.blogspot.com/
    Thursday, May 21, 2009 12:54 AM
  • OK. Thanks. But thats not fair for SPs, Functions.
    : )
    Thursday, May 21, 2009 3:59 PM