SQL security
From: Ray Higdon (rayhigdon_at_higdonconsulting.com)
Date: 07/02/03
- Next message: Cindy Gross: "RE: Distributed Transaction Coordinator"
- Previous message: mRod: "Cannot set permissions to public role."
- In reply to: Amy Wang: "SQL security"
- Next in thread: Amy: "SQL security"
- Reply: Amy: "SQL security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Tue, 1 Jul 2003 16:41:37 -0700
Did you add the group permissions today in SQL? If so,
did the restore take them out??
Ray Higdon MCSE, MCDBA, CCNA
>-----Original Message-----
>SQL 2000, windows 2000
>
>I am using window NT authentication. In SQL Server, I
give
>permission to NT group GROUP1. My NT login USER1 is the
>member of GROUP1.
>
>Get error when set up ODBC : Connection failed, sQL
state
>42000, SQl server error 4064. Can not open user default
>database. login failed.
>
>
>
>If I give permission to USER1 directly, It works.
>all SQL server login works.
>
>By the way, it worked before and not work after I
restore
>last night backup data. No change with user or any NT
>permissions
>
>Thanks
>.
>
- Next message: Cindy Gross: "RE: Distributed Transaction Coordinator"
- Previous message: mRod: "Cannot set permissions to public role."
- In reply to: Amy Wang: "SQL security"
- Next in thread: Amy: "SQL security"
- Reply: Amy: "SQL security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
