Winows NT Login

Hi,

Can someone assist me with the creation of a specific login for a SQL Server
2005 setup, I have a network login of "NETWORK/HDesk" on a Windows NT
network, what I want to do is grant this login access to 1 "table" in a
Database called "Database1" and the table name is "Table1", I also want to
grant this user access to 3 tables in another Database called Database2 and
the Tables are called "Table1, Table2, Table3", the problem with the second
database is, this gets deleted each evening and restored from a backup I am
sent from elsewhere. When I create the logins and assign them access to the
database this will be fine for Database1 but the login will be lost on
Database2 when its deleted and restored. I have also tried to assign
read/update permissions to a number of the tables and when I click ok they
disapear. If I can offer any further information please let me know,
although been doing SQL for some time, logins are always something that I
have struggled with.

Thanks P
.

Relevant Pages

  • Re: System Administrator Implied Permissions
    ... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
    (microsoft.public.sqlserver.security)
  • Re: No db access after publishing web site
    ... GRANT UPDATE TO ... If I detach and attach this database on a different PC (according that PC ... Cannot open database "pago" requested by the login. ... Are you detaching/attaching the SQL Server Express database correctly ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: cannot login to the db after...
    ... Jasper Smith (SQL Server MVP) ... I have created a new database, "db_1", using the "sa" ... I then created a new login, "sqluser1" and gave ...
    (microsoft.public.sqlserver.security)
  • Re: Cant view merge agent properties (trying again)
    ... In the List of Actions for the Snapshot Agent History I see this repeated: ... every single database listed. ... So, just now, I went to computername\Administrator Login ID (because it's ... On the computer running SQL Server, ...
    (microsoft.public.sqlserver.replication)
  • Re: Database security design with ASP.net and form-based authentication
    ... Since you already have forms-based security, why not use a single SQL login ... for all database access? ... data entry, guest/view only, admin, report viewer. ... so I'm using SQL Server authentication. ...
    (microsoft.public.sqlserver.security)