Question for Script of users permission. 
Author Message
 Question for Script of users permission.
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



Tue, 30 Aug 2005 18:39:19 GMT
 Question for Script of users permission.

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


Quote:
> 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



Tue, 30 Aug 2005 20:37:42 GMT
 Question for Script of users permission.
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

Quote:
>-----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



>> 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

>.



Wed, 31 Aug 2005 02:11:00 GMT
 Question for Script of users permission.
So, if you have logins and users, they may be not connected. You can check
the sp_resolve_logins system SP for SQL logins. For Windows users and
groups, check
http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B240872#4.
Hope this will help.

--
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



Wed, 31 Aug 2005 17:44:57 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. any body has a script to script users permissions on db objects

2. Need SQL Script to reverse-engineer datbase users, groups, permissions for SQL 6.5

3. Scripting Role Permissions and Users

4. Users/Logins/Permissions Script

5. Using PERMISSIONS to check permissions for other users

6. User permissions (SQL Server 6.5) question

7. user/role execute permission question

8. DB2->PostgreSQL question on user permissions and views

9. Copy permissions from user/group to different user/group

10. How to obtain information about user roles and user permissions on tables

11. How to obtain information about user roles and user permissions on tables

12. alter user to change user's password returns pg_shadow: Permission


 
Powered by phpBB® Forum Software