User_name on 229 error alert

From: LEO (leo.rocchi_at_infinito.it)
Date: 10/18/05

  • Next message: Tom Moreau: "Re: Dynamic SQL in Stored Proc" 
    Date: Tue, 18 Oct 2005 17:36:46 +0200

    On sql2K, I need the USER_NAME with alert on 229 error (%ls permission
    denied on object '%.*ls', database '%.*ls', owner '%.*ls'.)

    HOW ?
    Thanks

  • Next message: Tom Moreau: "Re: Dynamic SQL in Stored Proc"

    Relevant Pages

    • Re: Cross database update issue
      ... Also, for dbo-owned objects, the owner of both databases must be the ... You can execute sp_helpdb to determine the current database owners. ... > User Name: Test1 Role Name=Test ... > Role Test has select permission to table t_test ...
      (microsoft.public.sqlserver.security)
    • Re: PHP Query Issues on Ingres R3 Linux Version
      ... If a table is owned by the DBA (the database owner) then there is no ... "permission" thing so much as an object ownership issue. ... An object which is not prefixed by a schema name is found by looking ...
      (comp.databases.ingres)
    • Re: SP accessing other db
      ... And its dbo user was blank even db Properties shows BUILTIN\Administrator as ... Now the database name is hard-coded. ... > with System Admin permission. ... >> have the same owner so that the dbo users map to the same login. ...
      (microsoft.public.sqlserver.security)
    • Re: database split before or after security?
      ... I created a new database in Access 2003. ... As owner, I created a new database and imported ... database, as workgroup owner and imported queries, forms and reports, ... ModifyDesign permission on no tables. ...
      (microsoft.public.access.security)
    • Re: database split before or after security?
      ... I created a new database in Access 2003. ... As owner, I created a new database and imported ... database, as workgroup owner and imported queries, forms and reports, ... ModifyDesign permission on no tables. ...
      (microsoft.public.access.security)