Re: Question for Script of users permission.

From: NIITMALAD (NIITMALAD@YAHOO.CO.IN)
Date: 03/14/03 

From: "NIITMALAD" <NIITMALAD@YAHOO.CO.IN>
Date: Fri, 14 Mar 2003 10:11:00 -0800

DEAR DEJAN

I HAVE NOT GOT ANY ERROR.

BUT AS I AM USING THE SCRIPT ON THE MSDE FOR THE LOGIN
AND PERMISSION OF USERS. I AM NOT ABLE TO GET THE SAME
EFFECTED.

THE SIMPLE QUESTION IS HOW I CAN RESTORE MY DATABSE WITH
PERMISSION AND USERS.

YOUR GUIDANCE WILL HELP ME TO SOLVE THE PROBLEM.

BEST REGARDS
NIITMALAD

>-----Original Message-----
>What errors do you get? My guess is that you should have
scripted logins as
>well, but I can't be sure - not enough info in your post.
>
>--
>Dejan Sarka, SQL Server MVP
>FAQ from Neil & others at: http://www.sqlserverfaq.com
>Please reply only to the newsgroups.
>PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"NIITMALAD" <NIITMALAD@yahoo.co.in> wrote in message
>news:011001c2ea15$f7e5a3b0$3401280a@phx.gbl...
>> Dear Friends
>>
>> I have created a script for Users and roles so that i
can
>> restore the same if any problem arise in the SQL
Database.
>>
>> As i have only one SQL server I have check the same on
>> MSDE but it is not creating the USers and Roles as I
have
>> in my SQL server.
>>
>> Please suggest How i can test and be sure that i can
>> restore my users and roles and do not need to give the
>> permission for every object again in any disaster.
>>
>> Your guidance will be helpful for me to solve the
problem
>>
>> Thanks in Advance.
>> NIITMALAD
>
>
>.
>

Relevant Pages

  • Re: link table
    ... e.g. SELECT permission only on all tables. ... I use this procedure to re-create links to SQL Server. ... MsgBox "You must supply a DSN in order to link tables." ... > In this case, should use SQL's login ID, am I right? ...
    (microsoft.public.access.externaldata)
  • Re: Automatic chmod
    ... from login import login ... Subject: Automatic chmod ... I have a python script that automatically writes another script. ... is that you are trying to open a file you don't have permission to open. ...
    (freebsd-questions)
  • Re: Cannot open database requested in login
    ... authentication to sql server and windows... ... >DELL\VSdotNET is a Login and has been given permission to ... >database ITPSCustomers. ... >> The Windows user you are using to login to SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: Automatic chmod
    ... I should have mentioned the import of the login works for other scripts, ... I have a python script that automatically writes another script. ... Without seeing code, my first guess ... is that you are trying to open a file you don't have permission to open. ...
    (freebsd-questions)
  • Re: running scripts while login and logout
    ... > I wanted a script to be run as user while he logs out. ... Permission on directory. ... looks like root to me. ... >> This works for login out, for login in you can use the session-manual file or ...
    (Ubuntu)
Quantcast