Results 1 to 2 of 2

Thread: User Restrictions

  1. #1
    Join Date
    Aug 2005
    Posts
    3

    User Restrictions

    hai,
    i am a VB devekoper, and now working on a SQL Query Engine.... the appn. will QUERY the SQL Server(SQL)...i made the appn. to create a USER (say: QueryEngine), and i log in with the same UserName... now i want to set some restrictions for the User(QueryEngine) to provide READ-ONLY access, and that also through some SQL statements, so that i can quey the Server each time the appn is opened...
    i tried out the "GRANT" sql key word but it didn;t work oput...

    anybody has any solutions

    expecting the reply ASAP

    regards,
    abhay

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    User needs proper permission to execute grant statement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •