[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 154
  • Last Modified:

NEWBIE: Is SQL Server authority equal between Query Analyzer and Windows batch file?

Dear Experts,

I'm a newbie, and only vaguely aware of "mixed mode" security issues on SQL Server.

When I'm installing my product, I have the user sign me on to their SQL Server box "as" themselves (typically with all authorities).  I then use Query Analyzer to run a TQSL script to install the product.  (It creates a db, a login, grants a couple of authorities...)

To make this easier, I'm considering embedding that same TQSL into some Java, and then running that from a batch file on the user's desktop.  However, I'm not sure I'd have the same authorities double-clicking on a batch file while signed on to the SQL box itself as my customer as I would being inside QA as my customer.

Is there a fairly simple answer for this?

Thanks,
BrianMc1958
0
BrianMc1958
Asked:
BrianMc1958
  • 2
1 Solution
 
CEHJCommented:
>>
However, I'm not sure I'd have the same authorities double-clicking on a batch file while signed on to the SQL box itself as my customer as I would being inside QA as my customer.
>>

Don't see why not. They'd just put the same credentials into your app as they do in their db interface
0
 
BrianMc1958Author Commented:
To CEHJ: I'm afraid I didn't post this to the SQL Server forum as I intended.  Don't know how to correct, so I'll accept your answer here and repost...

Thanks...
0
 
CEHJCommented:
OK, but i think i'd put the same answer in there ;-)
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now