Sql Permissions Help ?

[littlemoon]

Sql server lo 'SECURITY' will be under 2 places okati database level and inkoti Sql level

question - suppose database name - 'USA' ani undi anduloo unde Users anii Sql Security logins lo create ayi undala?

Database restore chesthe automatic ga Sql level security lo logins update avthaya?

[size=4] [/size]

[size=4] e paina situations vache sariki kotha doubts vashtunayi -- logins ki users ki difference enti ? what is the need of sql level security? [/size][size=4] [/size]

[chinni005]

helf..

[loveindia]

Total server level lo unna Security tab lo unna users are eligible to access all the databases in that server, but each individual database will have security again where the user should be placed. appudu that means that user with his permission level can use that database ani.. without that only server level lo untey pani cheyadu.. When you restore a database to a previous state, aa point of time varaku daantlo unna logins maatramey load avtai.. after that restore point chesinavi emanna untey bisket avtai... malli add cheyyali...

[littlemoon]

[quote name='loveindia' timestamp='1362584218' post='1303374268']
Total server level lo unna Security tab lo unna users are eligible to access all the databases in that server, but each individual database will have security again where the user should be placed. appudu that means that user with his permission level can use that database ani.. without that only server level lo untey pani cheyadu.. When you restore a database to a previous state, aa point of time varaku daantlo unna logins maatramey load avtai.. after that restore point chesinavi emanna untey bisket avtai... malli add cheyyali...
[/quote]

'without that only server level lo untey pani cheyadu..' ardham kaledhu ? server level lo a user ki nenu 'USA' ane DB ki kuda access isthanu aina work kadhu antunara?

and I restored 'USA' database on to a new server .. means 1old server nunchi kotha data server loki restore chesanu

so ilanti apudu logins sql level lo load avavu antunara?

[mtkr]

Help...

[deals2buy]

[quote name='loveindia' timestamp='1362584218' post='1303374268']
Total server level lo unna Security tab lo unna users are eligible to access all the databases in that server, but each individual database will have security again where the user should be placed. appudu that means that user with his permission level can use that database ani.. without that only server level lo untey pani cheyadu.. When you restore a database to a previous state, aa point of time varaku daantlo unna logins maatramey load avtai.. after that restore point chesinavi emanna untey bisket avtai... malli add cheyyali...
[/quote]

[quote name='littlemoon' timestamp='1362585416' post='1303374403']

'without that only server level lo untey pani cheyadu..' ardham kaledhu ? server level lo a user ki nenu 'USA' ane DB ki kuda access isthanu aina work kadhu antunara?

and I restored 'USA' database on to a new server .. means 1old server nunchi kotha data server loki restore chesanu

so ilanti apudu logins sql level lo load avavu antunara?
[/quote]

what he meant is there will be roles to user at the server level and database level...sometimes table level or object level lo kuda untundi AFAIK

So, meeru Server level lo aa user ki access ichi, DB level lo ivvakapothe it doesn't work ani

nenu DBA kaadu so naaku inthakante ekkuva teleedu

[anandam2012]

[quote name='Kaarthikeya' timestamp='1362592100' post='1303375260']




what he meant is there will be roles to user at the server level and database level...sometimes table level or object level lo kuda untundi AFAIK

So, meeru Server level lo aa user ki access ichi, DB level lo ivvakapothe it doesn't work ani

nenu DBA kaadu so naaku inthakante ekkuva teleedu
[/quote]

[anandam2012]

[ghazni]

when you do a backup and restore sometimes if you created permissions manually on DB level it may not restore the permissions of that user...

we have to create agian the permissions.... it happened to me this once.... i am not DBA but this practically experienced....

[loveindia]

[quote name='littlemoon' timestamp='1362585416' post='1303374403']
'without that only server level lo untey pani cheyadu..' ardham kaledhu ? server level lo a user ki nenu 'USA' ane DB ki kuda access isthanu aina work kadhu antunara?

and I restored 'USA' database on to a new server .. means 1old server nunchi kotha data server loki restore chesanu

so ilanti apudu logins sql level lo load avavu antunara?
[/quote]

yes aa database lo kuda aa user ni specify cheyali... server level lo permission antey the user can access any database on that server but he needs permissions over that database again to access that particular database.. got it?

SERVER
Database -- USER
-- USER

Both should be there

[deals2buy]

[quote name='ghazni' timestamp='1362592746' post='1303375347']
when you do a backup and restore sometimes if you created permissions manually on DB level it may not restore the permissions of that user...

we have to create agian the permissions.... it happened to me this once.... i am not DBA but this practically experienced....
[/quote]
what do you mean by creating permissions manually? using GUI?

[deals2buy]

[quote name='loveindia' timestamp='1362592811' post='1303375357']
yes aa database lo kuda aa user ni specify cheyali... [b][color=#ff0000]server level lo permission antey the user can access any database on that server but he needs permissions over that database again to access that particular database.. got it?[/color][/b]

SERVER
Database -- USER
-- USER

Both should be there
[/quote]
could have been told much better..its confusing again

[Guest]

[quote name='littlemoon' timestamp='1362583575' post='1303374206']
Sql server lo 'SECURITY' will be under 2 places okati database level and inkoti Sql level

question - suppose database name - 'USA' ani undi anduloo unde Users anii Sql Security logins lo create ayi undala?

Database restore chesthe automatic ga Sql level security lo logins update avthaya?



[size=4]e paina situations vache sariki kotha doubts vashtunayi -- logins ki users ki difference enti ? what is the need of sql level security? [/size]
[/quote]


Login - used for server authentication, meaning it will let you in SQL server. This is at server level
Database User - Allows to access the database after authetication. This is at the database level
Database Role - If you want to restrict the database users permissions, you can create a role. For ex : I want only the user to execute the SPs but not to modify them etc.,

Every database user must be associated with a Login. Logins are stored in the master database and database users are stored in the database. When you restore the database, you need to transfer the logins also unless you restore the master database as well. Assuming the you have all corresponding Logins exist for the database users, after restoring their SIDs don't match, so you need run this SP sp_change_users_login 'report' to get the report and fix and update the SIDs one by one. Ex : sp_change_users_login 'update_one', 'test', 'test'.

[vegeta]

Login is server level, user is at database level. Each user in database must have a login (SQl account/windows account) associated with it.. If you restore a DB all windows logins will get re-associated with users, but SQL logins won't. they become orphan users in the database..you can fix them running

sp_change_users_login 'report'
sp_change_users_login 'auto_fix', 'user'

[ghazni]

[quote name='Kaarthikeya' timestamp='1362592817' post='1303375359']
what do you mean by creating permissions manually? using GUI?
[/quote]
emo naku oka db access ledu ma team mate vadiki anni permissions unayi so vadu nanu add chesadu aa db ki apudu i could access so idi manual ey kada.....